My bet is that there is a different list separator character in the Windows
regional settings than used in that .CSV file. (comma vs semi-colon???).

You could fiddle with the regional settings to make the list separator match the
separator in the .CSV file or maybe just rename the file to *.txt and you can
specify everything you want--including that delimiter.

pm tester wrote:

Hello,

I have a database that with US regional settings will export to an excel
spreadsheet in .CSV format multiple column headings.
The spreadsheet will have 3 column headings of | Location | Device |
Quantity |

But when I switch to a European regional setting such as Germany, the export
in .CSV format converts the data into a single column.
The spreadsheet will ahve 1 column displayed with | Location,Device,Quantity |

Is there a setting or a way to change this conversion from a single column
to multiple columns to mirror the US regional settings. I can not upload the
resulting .CSV file to a US DB because it says the .CSV format is invalid.

--

Dave Peterson