Can Access somehow zip files?

[mscertified]

My Access DB needs to output data for use in a data warehouse. Currently it
uses TRANSFERTEXT then creates an FTP upload script and shells to execute it.
This all works fine but the FTP transfer frequently times out because of the
size of the files (150 meg). They are fixed length (have to be) and thus
would benefit from being zipped. Is there any way I can zip the files from
within MS Access? Thanks.

 

[Daniel]

Take a look at

http://www.vbaccelerator.com/codelib/zip/zipvb.htm
http://c85.cemi.rssi.ru/access/TipDetail.idc?TipID=9

 

[Albert D. Kallal]

I have a working example that allow zipping with ms-access here:

http://www.members.shaw.ca/AlbertKallal/zip/index.htm

The above runs without you having to install winzip.
(and, you don't have to use shell coomands to
pkzip or installing pkzip).

 

[PACALA]

NO PROBLEMS, CONTACT ME...
--
PACALA JAN [ACCESS DEVELOPER]
SEND 10$ TO...
ACCOUNT:
SK31 1100 0000 0026 1674 0428
SwiftCode: TATRSKBX
Tatra banka as,Hodzovo nam.3, 811 06 Bratislava
(e-mail address removed)
SKYPE: PACALA.BA1

 

[tina]

these newsgroups are for the FREE exchange of ideas, information, and
assistance. this is absolutely NOT the place to troll for business, such
postings are not welcome, and they make such a bad impression that it can
only hurt your reputation in the Access community.

if you want to post actual advice and assistance here in the newsgroups for
all to benefit from, or post questions of your own, then your participation
will be welcomed.

NO PROBLEMS, CONTACT ME...
--
PACALA JAN [ACCESS DEVELOPER]
SEND 10$ TO...
ACCOUNT:
SK31 1100 0000 0026 1674 0428
SwiftCode: TATRSKBX
Tatra banka as,Hodzovo nam.3, 811 06 Bratislava
(e-mail address removed)
SKYPE: PACALA.BA1

My Access DB needs to output data for use in a data warehouse. Currently it
uses TRANSFERTEXT then creates an FTP upload script and shells to execute it.
This all works fine but the FTP transfer frequently times out because of the
size of the files (150 meg). They are fixed length (have to be) and thus
would benefit from being zipped. Is there any way I can zip the files from
within MS Access? Thanks.