unzip files from VBA

[JT]

Is it possible to unzip a file with VBA. I have a large file that I download
from an FTP site. If it is a zip file it takes 1 minute. If it is a text
file, it takes 10 minutes. So I would like to download the zip file if I can
unzip it with VBA.

Is it possible to import a zip file into an Access table with
DoCmd.TransferText acImportDelim command?

 

[Jesper Fjølner]

Is it possible to unzip a file with VBA. I have a large file that I

download
from an FTP site. If it is a zip file it takes 1 minute. If it is a text
file, it takes 10 minutes. So I would like to download the zip file if I
can
unzip it with VBA.

I just got i working with the ziputility from http://www.7-zip.org/
which has a commandline version.
The syntax is something like:
c:\7zip\7za.exe -e yourzipfile.zip yourextractedfile.zip
It has a lot of options.

I'm running it with:
Shell c:\7zip\7za.exe -e myzipfile.zip myextractedfile.mdb
or

ShellWait c:\7zip\7za.exe -e myzipfile.zip myextractedfile.mdb
using the ShellWait function from http://www.mvps.org/access/api/api0004.htm


Jesper Fjølner
Denmark