exporting results of a query or table in cvs format

  • Thread starter Thread starter Bibi
  • Start date Start date
B

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.
 
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
 
-- Thank you.
TIA
Bibi


Roger Carlson said:
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





.
Click to expand...
 
Back
Top