PM,

Text files have only the delimiter (comma). You're getting them. It's when
you're reopening the text file in Excel that Excel isn't recognizing the
comma because the European settings specify other delimiters (semicolon, I
think, for many European countries). So it stuffs them all into one column.
--
Earl Kiosterud
www.smokeylake.com

"pm tester" <pm wrote in message
...
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.