importing csv files- entire record goes into each column
Hi,
I think your current selecion is just a cell in cell A1, before downloading.
Select all
columns by clicking the left corner - Above row 1 and left of column A - and
then try downloading again. This will display all the data as stored in the
CSV file.
Note: Although the source file may be delimited, you are just specifying a
single cell as selection for importing data, therefore, Microsoft Excel
assumes that you want to import all your data only into that particular cell.
Challa Prabhu
"Bill" wrote:
This used to work before but now whenever I import a .csv file (I've
tried each one that used to work before) entire records are being put
into each column variable but the commas are still there. There must be
a setting for this (looks like it doesn't recognize the comma any more)
but darned if I can find it. I went into control panel and
Regional/Laguages-- Customize and it already said that the separator
char was a comma...
Anyplace else I can check?
thanks,
Bill
|