Re: Import CSV file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On 4/10/09 11:05 AM, in article 59b71ad0.-1@xxxxxxxxxxxxxxxxxxxxxxx,
"Bowtiejack@xxxxxxxxxxxxxxxx" <Bowtiejack@xxxxxxxxxxxxxxxx> wrote:

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.
Are you opening it with the Text import wizard? What are you specifying for
a delimiter?

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

.

Relevant Pages

  • Import CSV file
    ... 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. ...
    (microsoft.public.mac.office.excel)
  • Calculating Column Averages from a CSV File
    ... I am trying to calculate column averages (excluding 0's) for all the ... columns in a CSV file except the first column. ... perl code, perl is calculating the 2nd column's average 9 times rather ...
    (perl.beginners)
  • Re: Dataset not Clearing
    ... t> I am trying to clear my dataset each time I read a new csv file but ... t> foreach (string strFile in strFiles) ... t> It should be what is in the first row, first column of the table, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: When I open a *.CSV file, text appear in the first column? What c.
    ... When I open in Excel 2003 a CSV file, the text appear in the first column. ... Prev by Date: ...
    (microsoft.public.excel.setup)
  • Missing commas in csv save
    ... I have some code which copies a table from an Excel workbook, ... first column has no header at all. ... Normally this gets saved into a csv file as: ... favour by dropping it like it also drops empty rows etc. ...
    (microsoft.public.excel)