Export Table as comma delimeted csv file

[jaryszek]

Hi,

i am trying to export table/query with format like here:

The strange thing is that when i am opening file using US regional settings - i see each header in separate column, when i am opening it using my regional settings- polish settings in windows 10 - i see commas.
You can change your regional settings and check it by yourself

But main issue here is: how can i esport specific table/query to format like on the screen?

Is there any option or VBA to do that?

Please help,
Best,
Jacek

 

[Gasman]

According to my system the ; is a list separator for Poland, not a comma. So use that in an export specification?

 

[jaryszek]

hi Gasman,

as default i have decimal point set up to "," in Poland, in US they have "." so here is a problem.

Best,
Jacek

 

[Gasman]

Not decimal point, list separator.

As yours is ; the data is thought of as just one string.
In the USA or here in the UK that would be considered several strings of data.?

That is my interpretation of the problem, but I've been wrong several times recently.

 

[Uncle Gizmo]

That is my interpretation of the problem, but I've been wrong several times recently.

You can't be right all the time, well that's what my wife tells me....

Sent from my SM-G925F using Tapatalk

 

[jaryszek]

Hi Guys,

I solved the problem.
The solution is Export Data Wizard and:
1. Changing export file from default "txt" to "csv"
2. Changing separator to Comma
3. Changing decimal point to ",", not "."