Exporting table in .csv format

  • Thread starter Thread starter Tom Tripicchio
  • Start date Start date
T

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
 
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.
 
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.
 
Back
Top