Export Table as comma delimeted csv file (1 Viewer)

jaryszek · Jan 21, 2019

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 · Jan 21, 2019

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

jaryszek · Jan 21, 2019

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 · Jan 21, 2019

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 · Jan 21, 2019

Gasman said:
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 · Jan 21, 2019

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 "."

Export Table as comma delimeted csv file (1 Viewer)

jaryszek

Registered User.

Attachments

Gasman

Enthusiastic Amateur

jaryszek

Registered User.

Gasman

Enthusiastic Amateur

Uncle Gizmo

Nifty Access Guy

jaryszek

Registered User.

Attachments

Similar threads

Users who are viewing this thread