All columns not being recognized in .csv file.
Are the cells "blank" or Empty?
when I try with empty cells I get no comma, when I enter a single space in
them I get a comma, when I format them as Text I get a comma, even if there
is nothing in them.
"Decision Assist" wrote in
message ...
I have an .xls spreadsheet with 34 columns, all of which may or may not
include data. Data is entered on each line, but each line contains many
blank cells. When I save the file as a .csv file, all the columns are not
recognized. When viewed in notepad, some lines contain 28 commas; others
have the 34. If I import this file into my application, it returns many
errors for wrong number of columns. Has anyone run into this problem and
found a solution? Thanks.
|