Export Access 2010 table to csv with VBA
Posted on 2011-09-16
What's the easiest way in Access 2010 to export a table to a csv file. I used the following:
DoCmd.TransferText acExportDelim, , "Std Template RC", "D:\Documents and Settings\204064422\My Documents\GE\Testman Setup Interface\stdTemplate.rc"
But got a message that the table is read only and cannot be exported. Does this happen when you have the table open on a subform?
Also, if I can get past that problem, will the command above export a .csv or tab delimited?