[AccessD] A2K - Unzip and append from CD

Hi Reuben

OK, sorry for the misunderstanding.
I think - haven't done it myself - the Chilkat component can do that for you:

 - Create or open in-memory Zips. 
 - Provides in-memory access to compressed or uncompressed data. 

If the file is zipped or not, you can probably get that info as well from the Chilkat component, or you can open the file and check the two first characters to be "PK" and the third 03 (Bytes: 50 4B 03).

/gustav

>>> reuben at gfconsultants.com 10-01-2006 16:13:59 >>>
I meant I am planning to do it all in Access.  I mentioned Access because
you mentioned VB or VB Script...

What happens is...
1.  The state of Indiana sends a CD out with two or three zipped txt files
on it.
2.  The user needs to be able to browse to and select the appropriate file
to open.
3.  My app needs to unzip the file (I don't need the text file saved and
prefer not to save it) in order to read the text file
4.  The text file is comma delimited and the fields are always the same (so
the import specs should be easy)
5.  The records from the text file need to be appended to a table (the table
never changes)

Now, there is one issue with step one.  Sometimes the state forgets to zip
them and they come as just txt files.  I guess I'll just check the extension
after the user selects the file and act appropriately.

My real concern is how do I work with a zipped file?

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
> Sent: Tuesday, January 10, 2006 9:36 AM
> To: accessd at databaseadvisors.com 
> Subject: Re: [AccessD] A2K - Unzip and append from CD
>
>
> Hi Reuben
>
> If you tell a bit more someone might have an idea.
> How would you import a text file in Access without using Access ..?
>
> /gustav
>
> >>> reuben at gfconsultants.com 10-01-2006 15:17:36 >>>
> I'm confident I can do it in Access, but I was hoping somebody
> had something
> close just for the sake of time.
>
> Thanks for the links - I'll check them out.
>
> Reuben Cummings
> GFC, LLC
> 812.523.1017
>
>
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com 
> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
> > Sent: Tuesday, January 10, 2006 6:21 AM
> > To: accessd at databaseadvisors.com 
> > Subject: Re: [AccessD] A2K - Unzip and append from CD
> >
> >
> > Hi Reuben
> >
> > Can't you create a small VB, VBScript or Access app that does this?
> >
> > Mr. Colby has some zip routines I believe, or study here:
> >
> >   http://www.zlib.net/ 
> >
> > or have a control (not free) to do the dirty work:
> >
> >   http://www.chilkatsoft.com/zip-activex.asp 
> >
> > or simply run a command line tool like unzip.exe:
> >
> >   http://www.mame.net/downmain.html 
> >
> > /gustav
> >
> > >>> reuben at gfconsultants.com 09-01-2006 20:51 >>>
> > I need to append data to a table in Access.
> >
> > However, the data is in a zipped txt file on a CD.
> >
> > Anyone, have a way to allow the user to browse to the proper
> > file, unzip it,
> > and insert the data into Access in one motion?
> >
> > Thanks.
> >
> > Reuben Cummings
> > GFC, LLC
> > 812.523.1017