LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
pm tester
 
Posts: n/a
Default regional conversion of excel to .csv

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
EXCEL HEX2DEC conversion error Jerry Excel Worksheet Functions 4 June 16th 05 03:48 AM
excel templates currency conversion noel New Users to Excel 1 May 12th 05 04:41 PM
download a .csv file to Excel acwerth Excel Discussion (Misc queries) 3 February 15th 05 10:21 PM
Problems with Excel Horizontal arrays with regional options using. Dr. Strangelove Excel Discussion (Misc queries) 0 January 6th 05 03:41 PM


All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"