Compressing/Zipping Files from Access

[Guest]

Im sorry ... I may be somewhat thick here, however I am looking for a way to
compress csv files after I have imported them to access... I have found and
read the topics here and downloaded emandos code as suggested previously from
http://www.mvps.org/emorcillo/download/vb6/xpzip.zip

However this does not seem to work for me. I have imported the Class Module
and tried to call the functions there in with No Joy ... Infact I get the
error Sub or Function Not Defined when I call this from the immediate window
.... Im not sure whether I am missing a library file or something else ... (it
calls an IStorage type)

Can anyone give me some pointers as the code would appear to do exactly what
I require...

Sorry if this is a stupid question, however I am becoming somewhat frustrated

 

[Douglas J. Steele]

If I recall that code correctly, I don't think it's possible to use it
within Access. I'm pretty sure VBA doesn't expose the IStorage type, while
VB does.

 

[Guest]

Cheers Douglas

Disappointing though as it looks to [provide exactly the functionality I am
looking for without introducing any DDLs

--
Many Thanks Once Again

Regards

Alan

If I recall that code correctly, I don't think it's possible to use it
within Access. I'm pretty sure VBA doesn't expose the IStorage type, while
VB does.

 

[Stuart McCall]

Im sorry ... I may be somewhat thick here, however I am looking for a way
to
compress csv files after I have imported them to access... I have found
and
read the topics here and downloaded emandos code as suggested previously
from
http://www.mvps.org/emorcillo/download/vb6/xpzip.zip

However this does not seem to work for me. I have imported the Class
Module
and tried to call the functions there in with No Joy ... Infact I get the
error Sub or Function Not Defined when I call this from the immediate
window
... Im not sure whether I am missing a library file or something else ...
(it
calls an IStorage type)

Can anyone give me some pointers as the code would appear to do exactly
what
I require...

Sorry if this is a stupid question, however I am becoming somewhat
frustrated

You could give the free Zlib library a try:

http://www.zlib.net/

Known to work in vb/vba environments.

 

[Albert D. Kallal]

Im sorry ... I may be somewhat thick here, however I am looking for a way
to
compress csv files after I have imported them to access...

You mean exported data from MS access right?

Why on earth would you take some data file, and then put it inside MS access
as a compressed zip file?

What possible benefit or advantage would these files have?

You'll not be able to open and query or report or use this data inside of
ms-access with any of that tools that MS access has for reporting on data.

However if you must take some files and compress them before you import them
into some kind of binary objects inside MS access, then use my zippling
libary code for ms-access. you can find it here:

I have a zipping routine 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).

The above download does require that you do a place a DLL in the same
directory as the MDB, or MDE file, but there's no softer installation of any
kind.