Import CSV file

B

Bowtiejack

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When I try to import a CSV file (downloaded from Etrade), everything is posted in the first column with the commas intact.

I tried saving it as an Excel CSV file and re-importing. Same thing.

On the re-import, everything looks OK on the preview, but it still piles everything into the first column.
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When I try to import a CSV file (downloaded from Etrade), everything is posted
in the first column with the commas intact.

I tried saving it as an Excel CSV file and re-importing. Same thing.

On the re-import, everything looks OK on the preview, but it still piles
everything into the first column.
Click to expand...
Are you opening it with the Text import wizard? What are you specifying for
a delimiter?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting CSV files to Excel 7
Cannot choose export options for CSV files 2
Sorting a CSV text file 0
Exporting .csv into mail program database 3
can list of emails be transferred to safari address book? 7
Semicolons instead of Commas on formulas and CSV files. 0
losing quotes when saving CSV for website 1
csv file wont convert correctly in excel 5

Top