Importing CSV (External Data) Wrong Rows

[TJC86]

Hi,

I'm trying to import a CSV file using the "Get External Data" - "From Text" section in Excel.

I have a CSV file that is auto updated by a macro so I want to import this into a normal Excel workbook automatically to manipulate and format etc.

When I import it though, about a quarter of the headings (Row 1) appear on line 2, starting in COl A again.

THis definitely isn;t the case in the normal CSV file. I've tried different qualifiers, and even changing the "," to ",-," in Region and Language options with no success.

Please help!

Thanks.

 

[saeedkk]

Hello,

sounds you are exporting from a call manager ( ) anyways check the text file on a text editor because if the text file is delimited correctly then excel wont have problems at all ..

Regards

 

[TJC86]

Hi, thanks for your response. Nope, not a call manager!

But anyway, I've found the problem now thank you.

I had the file formatted as a table before I decided to change to a CSV and I had used ALT+Enter to put half the title on another line but in the same cell. Absolute Nightmare!

Happy days!