I want to export (ACCESS 2007) from a table or query in CSV (comma seperated values)
I need this to import into GMAIL of other mail systems.
I use the following:
DoCmd.TransferText acExportDelim, "Export-Leden", "Qry Leden", "c:\BergsePlaat\Leden.csv"
In which:
"Qry Leden" is the query
"c:\BergsePlaat\Leden.csv" is the file to fill with the CSV
"c:\BergsePlaat\Leden.csv" is the export specification
If I do not specify a specification I get the error: Field Separation delimiter is the same as decimal delimiter
(I had to translate from Dutch into English so it is not exactly)
If I specify, the system tells me that the specification could not be found.
I created the specification by using the export wizard and store the specification. If I click manually on that specification is works fine.
How to solve??
I need this to import into GMAIL of other mail systems.
I use the following:
DoCmd.TransferText acExportDelim, "Export-Leden", "Qry Leden", "c:\BergsePlaat\Leden.csv"
In which:
"Qry Leden" is the query
"c:\BergsePlaat\Leden.csv" is the file to fill with the CSV
"c:\BergsePlaat\Leden.csv" is the export specification
If I do not specify a specification I get the error: Field Separation delimiter is the same as decimal delimiter
(I had to translate from Dutch into English so it is not exactly)
If I specify, the system tells me that the specification could not be found.
I created the specification by using the export wizard and store the specification. If I click manually on that specification is works fine.
How to solve??