[AccessD] A2K - Unzip and append from CD

Reuben,

I went through this back in May (search archives for subjects "[AccessD] 
Unzip Files" and  "[AccessD] Unzip Files Part II ")...I was using A2k on XP 
and was trying to call the decompress/unzip function of XP.  This did not go 
well.  The easiest solution was to pay to register WINZIP and use their 
command line function(they even give you directions)...but this means there 
would have to be a registered copy on WINZIP on each machine using the app.  
My app retrieved via ftp,unzipped,imported,then deleted the zipped and 
unzipped files.

If I could have found a somewhat easy way without paying I would have.  Hope 
this helps.

Mark A. Matte


>From: "Reuben Cummings" <reuben at gfconsultants.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] A2K - Unzip  and append from CD
>Date: Tue, 10 Jan 2006 10:13:59 -0500
>
>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
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com