Help on import csv to excel

A

Alan Tang

Hello:

I have a csv file that have more then 288 column. Is it possible to
import the csv file in excel?

Is it possible to import the file from the csv's row to excel's column?

Thanks !
 
H

Harlan Grove

Alan Tang said:
I have a csv file that have more then 288 column. Is it possible to
import the csv file in excel?

Is it possible to import the file from the csv's row to excel's column?
Click to expand...

No and no, and you can't import it as a plain text file because Excel will
truncate each line at 255 characters. You'd need VBA to do this in Excel,
but it's possible the software that created this CSV file would be the
better system to use to create CSV files derived from this original with 256
or fewer fields in each.

If you want to go the VBA route, it requires using VBA's Open, Input and
Close, which can be slow. As for processing each line of the CSV file, can
records contain newlines in quoted fields? Are embedded quotes in quoted
fields (if any) represented as "" or as \"?
 
Top