export data from Microsoft Access to csv

[Guest]

Hi,

How do I export data from an Access query or table to a csv file?

Thanks in advance

 

[MasterGaurav \(www.edujini-labs.com\)]

Hi,

How do I export data from an Access query or table to a csv file?

I don't think there's a direct mechanism available.
You can probably write a simple code for the same... it should be pretty
straight forward.


--
Happy Hacking,
Gaurav Vaish | www.mastergaurav.com
www.edujini-labs.com
http://eduzine.edujini-labs.com
-----------------------------------------

 

[Rad [Visual C# MVP]]

Hi,

How do I export data from an Access query or table to a csv file?

Thanks in advance

Take a look at a libary called FileHelpers. Perfect for exactly this sort
of thing.

Alternatively if you have access to SQL 2000 you can use DTS (SSIS for SQL
2005) to accomplish the same thing.