Bundle csv files

  • Thread starter Thread starter mpfohl
  • Start date Start date
M

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?
 
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?
Click to expand...

Your first and last setp should be here:
 
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?
Click to expand...

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.
 
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?
 
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?
Click to expand...

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
 
Back
Top