Excel CSV files

E

east

We use large CSV files to move data. recently added 3 blanks columns to end
of file for future use. Unless we add dummy char. to these columns Excel will
only upload 16 rows. We prefer not to put dummy char. in columsn only to have
the need to change them later. whats with the 16 row limit?
 
P

Pete

I don't think there is a limit - if Excel sees that a column is empty
then it won't try to export it. Try putting a single space in Q1, R1
and S1 (or a heading) and see if that cures it.

Pete
 
D

Dave Peterson

Open it (select delimited, other and use the caret).

Save it as a new name *.csv.
 
D

Dave Peterson

Open excel
File|open
point at your .dat file.
On the first step of the text import wizard, you'll see two options--delimited
and fixed width.

Choose delimited.

Follow the rest of the wizard to import your file.
 
Top