Discussion:
Export Access Query to a pipe delimited .csv file
(too old to reply)
PSULionRP
2010-03-09 14:27:01 UTC
Permalink
Fairly new to Access VBA.

How can I export an Access Query to a pipe delimited .csv file???

I believe the VBA Syntax is...

DoCmd.TransferText acExportDelim, _
"Specification Name", "qry_name", "C:\PathName\FileName.csv"

How do I specify and indicate to make it pipe delimited, "|"???

Thanks for your review and hopeful for a replay.

PSULionRP
Chris
2010-03-09 14:41:01 UTC
Permalink
You would set that up in your specification, and save it. That would be the
"specification name" parameter.
Post by PSULionRP
Fairly new to Access VBA.
How can I export an Access Query to a pipe delimited .csv file???
I believe the VBA Syntax is...
DoCmd.TransferText acExportDelim, _
"Specification Name", "qry_name", "C:\PathName\FileName.csv"
How do I specify and indicate to make it pipe delimited, "|"???
Thanks for your review and hopeful for a replay.
PSULionRP
PSULionRP
2010-03-09 14:50:05 UTC
Permalink
Can you be a little more specific Chris?? This is the first time I have ever
attempted this. Or provide me an education link that might explain this in
detail?

Thanks Chris.
Post by Chris
You would set that up in your specification, and save it. That would be the
"specification name" parameter.
Post by PSULionRP
Fairly new to Access VBA.
How can I export an Access Query to a pipe delimited .csv file???
I believe the VBA Syntax is...
DoCmd.TransferText acExportDelim, _
"Specification Name", "qry_name", "C:\PathName\FileName.csv"
How do I specify and indicate to make it pipe delimited, "|"???
Thanks for your review and hopeful for a replay.
PSULionRP
Chris
2010-03-09 15:39:01 UTC
Permalink
First, you need to create a query that selects all the data that you want.
Save it. Then, run the query, and click on FILE, EXPORT. You will get the
export query window. Under the SAVE AS TYPE dropdown, select text files and
then click on export. The export text window will appear. Select delimited,
enter the pipe symbol for delimiter, and click on advanced. Then, select
SAVE AS, and enter a name. This will be the "Specification Name". Save the
query. The query name will be "qry_name".

Hope this helps.
Post by PSULionRP
Can you be a little more specific Chris?? This is the first time I have ever
attempted this. Or provide me an education link that might explain this in
detail?
Thanks Chris.
Post by Chris
You would set that up in your specification, and save it. That would be the
"specification name" parameter.
Post by PSULionRP
Fairly new to Access VBA.
How can I export an Access Query to a pipe delimited .csv file???
I believe the VBA Syntax is...
DoCmd.TransferText acExportDelim, _
"Specification Name", "qry_name", "C:\PathName\FileName.csv"
How do I specify and indicate to make it pipe delimited, "|"???
Thanks for your review and hopeful for a replay.
PSULionRP
De Jager
2010-03-13 17:34:23 UTC
Permalink
Post by PSULionRP
Fairly new to Access VBA.
How can I export an Access Query to a pipe delimited .csv file???
I believe the VBA Syntax is...
DoCmd.TransferText acExportDelim, _
"Specification Name", "qry_name", "C:\PathName\FileName.csv"
How do I specify and indicate to make it pipe delimited, "|"???
Thanks for your review and hopeful for a replay.
PSULionRP
joelgeraldine
2010-03-17 13:37:05 UTC
Permalink
yhhhhhh
Post by PSULionRP
Fairly new to Access VBA.
How can I export an Access Query to a pipe delimited .csv file???
I believe the VBA Syntax is...
DoCmd.TransferText acExportDelim, _
"Specification Name", "qry_name", "C:\PathName\FileName.csv"
How do I specify and indicate to make it pipe delimited, "|"???
Thanks for your review and hopeful for a replay.
PSULionRP
Loading...