Re: Compressing/Zipping Files from Access
Douglas J. Steele
within Access. I'm pretty sure VBA doesn't expose the IStorage type, while
VB does.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Alan" <Al...@discussions.microsoft.com> wrote in message
news:704984AD-3C2F-4441...@microsoft.com...
> 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
> --
> Many Thanks
>
> Alan
Alan
Disappointing though as it looks to [provide exactly the functionality I am
looking for without introducing any DDLs
--
Many Thanks Once Again
Regards
Alan
Stuart McCall
You could give the free Zlib library a try:
Known to work in vb/vba environments.
Albert D. Kallal
news:704984AD-3C2F-4441...@microsoft.com...
> 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.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOO...@msn.com