[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