Is it possible to export to CSV file format?

[Mark Baker]

A client would like us to provide the reultsof a query in a .csv file
format. It is not an option in the export wizard, but i have heard that is
can be done. Is there a way to do this directly from access or would I neeed
to write a macro or similar?

 

[KC-Mass]

Hi Mark

It is there. If you open your query to a datasheet view you can then go to
the File\Export Menu.
Where it shows Access MDB scroll down and pick Text. In the next two panes
you get to pick delimiters
Select comma as the delimiter and you have a text file of Comma Seperated
Values or a CSV File.

Regards
Kevin

 

[Mark Baker]

Thanks, you are right - it is there...I made the mistake of assuming that as
windows automatically associates csv files with Excel that it would be an
option in the export to excel process! I also assumed that there would be a
way of actaully saving a .csv file and not that I would have to manually
adjust the file extension on a text file to save with a .csv extension.

Lesson learnt - never assume! And definitely never assume that MS products
are as complete as they make out.

Sorry for the sarcasm,
Thanks for the solution once more!

Mark