.csv format for Access table data

[Nene75]

hi everyone,

I am using MS Access 2000.

Is there a way to convert Access table into .csv (comma seperated Values) format using Macro or VBA?

Any help provided would be appreciated.

Thanks!

 

[GHolden]

Hi,

You can export a table to csv format using the TransferText comand.

eg.

DoCmd.TransferText acExportDelim, , "tblName", "C:\Test.csv"

Exports table 'tblName' to 'C:\Test.csv' as comma delimited. See Access Help on TransferText for more information.



There are two ways to write error-free programs; only the third one works.