Hello,
I'm using Microsoft Access 2010 and I want to do an export to a .csv file from a query.
I can to do an export to .xlxs. So that works.
But when I want to do an export to a .csv file than I get the message the "specname" file (this is the config how to do the export like no " and so one) doesn't exists.
The weird thing is the this file exist in the database.
I did right click and follow the steps. And the end I did 'save exportsteps'. I give it the name 'exporttocsv'.
When I do the vba command docmd.transfertext acexportdelim, "exporttocsv", ........... (and the rest)
Then I get the message : exporttocsv doesn't exist. But the file exist. If you do menu - extern data - save exportdata then I see the file.
When I choose 'run' I got the file.
So what went wrong ?
I read on internet that since Access 2010 it isn't possible to do an export with the vba command.
That you have to use the schema.ini file.
Is that correct ?
If yes, is there a script that can create the schema.ini automatically.
Thanks and regards.