Bundle csv files

[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?

[Ray Cassick]

<mp****@hotmail.comwrote in message
news:11**********************@c35g2000hsg.googlegr oups.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:

[Ray Cassick]

<mp****@hotmail.comwrote in message
news:11**********************@c35g2000hsg.googlegr oups.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/OpenSourc...b/Default.aspx

I have used this and it works great.

[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

[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?

[Andrew Morton]

mp****@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