exporting results of a query or table in cvs format

[Bibi]

I was asked to create a query that could be exported in excel format. A web
person would then integrate the data into a website for users to view
current data. I have created the query and can also create a Make Table
query if needed.
But the web people have come back to me and now say they need the data in
cvs format.....I can not find how to do this.....thoughts? Suggestions?
Please help.

 

[PieterLinden via AccessMonster.com]

I was asked to create a query that could be exported in excel format. A web
person would then integrate the data into a website for users to view
current data. I have created the query and can also create a Make Table
query if needed.
But the web people have come back to me and now say they need the data in
cvs format.....I can not find how to do this.....thoughts? Suggestions?
Please help.

Read this thread...
http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/b3b17f85-ed1b-4df4-848f-75a2d495e1b4


Works a champ.

 

[Roger Carlson]

It's really just like exporting to Excel, except instead of selecting Excel
as the file type, you select Text (and name it with a .csv extension). The
wizard will walk you through the rest.

If you're going to be doing this on a regular basis, you can create a macro
with the TransferText action, fill in the values you want (make sure you
designate it as an Export), then you can simply run that macro every time.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Bibi]

-- Thank you.
TIA
Bibi

It's really just like exporting to Excel, except instead of selecting Excel
as the file type, you select Text (and name it with a .csv extension). The
wizard will walk you through the rest.

If you're going to be doing this on a regular basis, you can create a macro
with the TransferText action, fill in the values you want (make sure you
designate it as an Export), then you can simply run that macro every time.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L





.

 

[Bibi]

Thank you.
--
TIA
Bibi

Read this thread...
http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/b3b17f85-ed1b-4df4-848f-75a2d495e1b4


Works a champ.

--



.