LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 87
Default Problem with CSV file

A customer has sent me a csv file which contains two sheets when opened in
Excel 2000. This was done because the first sheet contained the maximum
number of records Excel can handle. I need to import these lists into
Paradox (a database), so I need to separate the two sheets into separate
files, each saved as its own csv.

In one of the columns, I've got long strings of data as shown below. These
are UPC codes, and will never be used as numbers - just text.

10323900002958
10323900002965
16500505693
10323900005409
10323900006147
10015400022436

When I separate the two sheets into their own notebooks, and save as csv
files with new names, a problem arises. When I either import the data into
Paradox, or reopen the sheets in Excel, I find that this is what's happened
to the list shown above:

1.03239E+13
1.03239E+13
16500505693
1.03239E+13
1.03239E+13
1.00154E+13

The shortest value is untouched, but the rest convert to exponent format.
So, I figured Excel was seeing these as numbers. I opened a new sheet,
formatted all cells as text, and tried copying the data to that sheet, using
Paste Special / Values. Same problem. I'm am definitely choosing the right
file type before doing the Save As.

Even stranger: If I view the new csv file in a text editor like WinEdit,
these strings look fine.

Help!


 
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
problem opening file Markb Excel Discussion (Misc queries) 7 January 3rd 10 08:03 PM
Problem with csv file herbivore Excel Discussion (Misc queries) 3 July 21st 06 01:44 AM
I got a problem when tried to open the file! wsjoo Excel Discussion (Misc queries) 2 June 16th 06 08:11 AM
File Name Problem Philg Excel Discussion (Misc queries) 2 September 21st 05 07:07 PM
CSV file problem Linn Kubler Excel Discussion (Misc queries) 2 December 14th 04 05:14 AM


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

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

About Us

"It's about Microsoft Excel"