Hi Guys,
i want to export selected queries to separated csv files and do it via VBA.
The problem is that my standard settings of Access are:
And i have to always go to advance --> and change decimal symbol from ";" to "." and Field delimeter from ";" to ",".
Is there any command to do this? I saw there is transferText but there is no way to set up these fields above.
What can i do? - my thoughts:
1. Change general Field delimeters and decimal symbol in Access only when code is running and return them back after export
2. Find the method which can change the automatically in VBA.
Please help with this,
Best,
Jacek
i want to export selected queries to separated csv files and do it via VBA.
The problem is that my standard settings of Access are:
And i have to always go to advance --> and change decimal symbol from ";" to "." and Field delimeter from ";" to ",".
Is there any command to do this? I saw there is transferText but there is no way to set up these fields above.
What can i do? - my thoughts:
1. Change general Field delimeters and decimal symbol in Access only when code is running and return them back after export
2. Find the method which can change the automatically in VBA.
Please help with this,
Best,
Jacek