|
 |
access_asp thread: Extracting data from Access, attaching to email as .csv file
Message #1 by "Cindi Simonson" <simon@r...> on Thu, 3 Oct 2002 02:49:37
|
|
Hello,
As a newbie, is there an easy solution to extracting all data from an
Access database and attaching it to an email as a .csv file?
Sincerely,
Cindi S.
Message #2 by "Larry Woods" <larry@l...> on Wed, 2 Oct 2002 20:09:57 -0700
|
|
Sure. Just go to File/Export and export the table as a .csv.
Larry Woods MCSD, MCT
l.woods, inc.
> -----Original Message-----
> From: Cindi Simonson [mailto:simon@r...]
> Sent: Thursday, October 03, 2002 2:50 AM
> To: Access ASP
> Subject: [access_asp] Extracting data from Access,
> attaching to email as
> .csv file
>
>
> Hello,
>
> As a newbie, is there an easy solution to extracting
> all data from an
> Access database and attaching it to an email as a .csv file?
>
> Sincerely,
>
> Cindi S.
>
Message #3 by "Cindi Simonson" <simon@r...> on Thu, 3 Oct 2002 12:19:35
|
|
Thank you. I should probably have used more detail within my question. What I'm trying to
do is when the user submits a web form, how would one use asp to extract the data from the
Access database and then create a .csv file for attachment to an email?
Sincerely,
Cindi S.
> Sure. Just go to File/Export and export the table as a .csv.
Larry Woods MCSD, MCT
l.woods, inc.
> -----Original Message-----
> From: Cindi Simonson [mailto:simon@r...]
> Sent: Thursday, October 03, 2002 2:50 AM
> To: Access ASP
> Subject: [access_asp] Extracting data from Access,
> attaching to email as
> .csv file
>
>
> Hello,
>
> As a newbie, is there an easy solution to extracting
> all data from an
> Access database and attaching it to an email as a .csv file?
>
> Sincerely,
>
> Cindi S.
>
Message #4 by "Ken Schaefer" <ken@a...> on Fri, 4 Oct 2002 15:58:15 +1000
|
|
Build an SQL statement.
Execute the SQL Statement returning an resultset which you put into an
ADODB.Recordset object
Call .GetString to turn this into the format you want
Then use the FSO to write out the file. Attach it to your email.
The following page has necessary code:
http://www.aspalliance.com/aspguru/csvfile.aspx
however it uses a recordset loop to create the data, whereas I think
.GetString will be faster.
Info on .GetString:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/
mdmthgetstringmethod(recordset)ado.asp?frame=true
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Cindi Simonson" <simon@r...>
To: "Access ASP" <access_asp@p...>
Sent: Thursday, October 03, 2002 12:19 PM
Subject: [access_asp] RE: Extracting data from Access, attaching to email as
.csv file
: Thank you. I should probably have used more detail within my question.
What I'm trying to
: do is when the user submits a web form, how would one use asp to extract
the data from the
: Access database and then create a .csv file for attachment to an email?
:
: Sincerely,
:
: Cindi S.
|
|
|
View Cart
