Bundle csv files

3 May 2007 1:57 AM

mpfohl

I have an MS access database. I have a button the user clicks to
export the 8 tables into csv files for them to then easily email to
me.

Right now, the user must attach all 8 csv files to email to me. Is
there a way to some how programatically 'bundle' those 8 files
together as one file to send to me? I'm not sure if there is a way to
'zip' files through VB, but in the end i'm not sure if I can count on
the user having winzip installed on their computer.

I know another thought is to export to one excel file and have a
differnet table for each tab, but an excel file is much larger than
the csv and i'm trying to keep size down. but maybe this is really my
ownly option.

Any suggestions?

3 May 2007 5:08 AM

Ray Cassick

<mpf***@hotmail.com> wrote in message
Show quoteHide quote

news:1178157440.312605.190840@c35g2000hsg.googlegroups.com...
>I have an MS access database. I have a button the user clicks to
> export the 8 tables into csv files for them to then easily email to
> me.
>
> Right now, the user must attach all 8 csv files to email to me. Is
> there a way to some how programatically 'bundle' those 8 files
> together as one file to send to me? I'm not sure if there is a way to
> 'zip' files through VB, but in the end i'm not sure if I can count on
> the user having winzip installed on their computer.
>
> I know another thought is to export to one excel file and have a
> differnet table for each tab, but an excel file is much larger than
> the csv and i'm trying to keep size down. but maybe this is really my
> ownly option.
>
> Any suggestions?
>

Your first and last setp should be here:

3 May 2007 5:09 AM

Ray Cassick

<mpf***@hotmail.com> wrote in message
Show quoteHide quote

news:1178157440.312605.190840@c35g2000hsg.googlegroups.com...
>I have an MS access database. I have a button the user clicks to
> export the 8 tables into csv files for them to then easily email to
> me.
>
> Right now, the user must attach all 8 csv files to email to me. Is
> there a way to some how programatically 'bundle' those 8 files
> together as one file to send to me? I'm not sure if there is a way to
> 'zip' files through VB, but in the end i'm not sure if I can count on
> the user having winzip installed on their computer.
>
> I know another thought is to export to one excel file and have a
> differnet table for each tab, but an excel file is much larger than
> the csv and i'm trying to keep size down. but maybe this is really my
> ownly option.
>
> Any suggestions?
>

Ok, now I am going to give you the link :)

http://www.icsharpcode.net/OpenSource/SharpZipLib/Default.aspx

I have used this and it works great.

3 May 2007 7:36 AM

Robin Tucker

Hi mpfohl,

..NET 2.0 supports the GZIP compression algorithm through the GZIP stream
class. You can combine and zip your files using this method if you don't
want to go and get a 3rd party library. However there will be some coding
involved for your specific needs ;).

http://msdn2.microsoft.com/en-us/library/ms404280.aspx

Robin

3 May 2007 1:48 PM

mpfohl

Robin, that looks exactly like what i'm looking for, but unfortunatly
i'm not sure .net 3.0 code works in Ms. Access 2003, or am I missing
something? Is there a way to reference that library or something?

As I mentioned, i'm purchasing visual studios, will that take care of
that problem?

3 May 2007 1:55 PM

Andrew Morton

mpf***@hotmail.com wrote:

> Robin, that looks exactly like what i'm looking for, but unfortunatly
> i'm not sure .net 3.0 code works in Ms. Access 2003, or am I missing
> something? Is there a way to reference that library or something?

I think you're in the wrong newsgroup as it looks like you're asking about
VB in Access, however, can't you write all the csv data to one file with
some sort of separator so that you can split them when you're received the
email?

Andrew