Exporting table in .csv format

[Tom Tripicchio]

I have access 97. I know how to export a table in excel format, but I do not
see as 1 of my choices to export in a .csv format. Is that possible? My
choices are Dbase, excel, paradox, fox pro, lotus etc. But no .csv format.

Thanks

 

[ParticleHead]

use *.txt

 

[Douglas J. Steele]

Programmatically or through the GUI?

In either case, try looking for the file mstext35.dll on your hard drive (it
should be in the Windows System folder) and use regsvr32.exe to reregister
it.

 

[Tom Tripicchio]

I have .txt as a choice. But should .csv be a choice also?

 

[Douglas J. Steele]

Programmatically or through the GUI?

If you've got a table selected, choose File | Save As/Export... and choose
the To an External File or Database radio button, the second choice in the
Save Table dialog should be Text Files (*.txt;*.csv;*.tab;*.asc)

When the Export Text Wizard comes up, click on the Advanced button in the
bottom left-hand corner. You'll have a choice of Delimited or Fixed Width.
Choose Delimited, and make sure the Field Delimiter is set to ,

If you're using the TransferText method, you can specify acExportDelim as
the transfer type.