Zipping and FTP'ing from within Access 97

[GreenFella]

Howdy.

Is there anyway to execute a popular Zip program (WinZip or PKZip) from within Access 97 and then intiate an FTP session to send the zipped file to a specific FTP site.

TIA
Greenfella

 

[RobCPA]

You can programmatically add a file to a zip file using a Shell statement and Winzip's command line. For example:

Shell "c:\program files\winzip\wzzip -a c:\mydata\mytest.zip c:\mydata\mytest.txt"

creates the mytest.zip file with the mytest.txt file.

You'll need to download and install the WinZip Command Line Support Add-On which you can find at:

http://www.winzip.com/wzcline.htm

The add-on comes with a help file that details the necessary parameters.

I haven't done much with ftp, so cannot offer assistance with that.


Rob

 

[RobCPA]

I just found out also that you can call the actual Winzip32 program without having to install the add-on. The only thing that changed in the following example is that I'm calling the winzip32 program rather than the wzzip add-on program. I've also attached the link to the specific website page.

Shell "c:\program files\winzip\winzip32 -a c:\mydata\mytest.zip c:\mydata\mytest.txt"

http://www.winzip.com/xcmdline.htm