Export to Zip

[BrianPS]

I have an export function in an Access XP db that grabs five tables/queries
and exports as five .csv text files. I would like to be able to zip those
five files into a single WinZip file. Is there a way to automate this process
in Access? Ideally, I would like the user to just push the button and end up
with the zip file in the directory I've indicated, rather than the five text
files.

Thanks,
Brian

 

[Douglas J. Steele]

If you've already got WinZip, one option is to get the free Command Line
Support add-in from http://www.winzip.com/downcl.htm You'll then be able to
use the Shell command to get WinZip to do what you want.

Another option is to take a look at the various compression controls Tony
Toews documents at http://www.granite.ab.ca/access/compression.htm