ETL and Data Integration tools - Modern ETL software for everyone

I’m trying to load Excel spreadsheet.

I cannot see all the data in Col1 for some reason.

I can see all the numbers, but not the text in the last few rows. The format is set to General in Excel.

Any ideas?

Thx
Dave

David

Excel ODBC driver scans first 8 rows to determine type of field.
In your case first rows has only numbers so your type is numeric, if later driver finds some records with character values it returns null
This one of most annoying features of Excel driver

You may also try setting TypeGuessRows to 0
support.microsoft.com/kb/189897
It might help you but it did not help me

You may also try putting records with character values first so the driver will use right data type
Or just use csv instead of EXCEL

Mike

Mike,

OK that is very useful info. I will reverse order the field to make the chars come out first and give it a whirl.

Thx.