Zipping and excel file using Access

L

losmac

You can't zip a Excel file using Sql instructions!
You can use sql instructions to create query, create
table, update table and ...

You can zip *.xls file only if You have zip program and
this program can work in command line mode. Using Shell
function, put the path to program with parameters to zip
or unzip file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Default local file location - folder redirection slowness 0
Word 97 Password 0
Run a Winzip self extracting file 5
Insert multiple objects at once ? 3
Access Lock File .LACCDB / Now shows as a notepad file 0
WinZip automation: using wzunzip -v to extract archive content inf 5
How to kill the zipped files in C:\Document and Settings\LogginName\Temp\ using code for this strang 2

Top