Access files to CSV

[spr]

I'm trying to read from an MS-Access file and convert into a CSV format. How do I go about this? Any suggestions?
THanks in advance.

 

[culshaja]

You use the Access Export utility, and choose the CSV option.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[TomSark]

You could also do this in DTS as well by selecting your transformation destination data source as being a text file...

Tom

 

[culshaja]

Thats a tad overkill for an Access database though. its also machine dependant, wheras the use of the Access export is database dependant and moves around with the access database.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305