Excel 255 character truncation

Mike

I am trying to load data from Excel file via ODBC.
However, it seems that cells with more than 255 characters in won't load.
How can I get around this? i.e. load cells with text longer than 255 characters.
On the link you originally sent me there is mention of a "Memo" field which allows more than 255 chars... can this be defined for Excel?

regards,
George

Put some dummy data before the first row an make sure that length is more than 255 characters.

Why you are using odbc any way?

Mike

Mike

I tried literally putting this record on rows 1 and 2 of the Excel sheet and it has worked, i.e. accepted definition as being more than 255 chars. In the Reader tab the "Show Definition" page indicates that size/precision is 1073741824 and datatype is blank (rather than 255 and VARCHAR as previously).

Can this be solved without having to create/copy dummy records?

I am using ODBS because I am running using SQL to join several Excel Sheets together

regards
George

So far I was not able to find an alternative solution for it

Mike

Mike

No that's fine, but I just need to know if you think there is a solution possible (even if unknown at the moment) or if this is a limitation of the MS ODBC driver and the only workaround is to edit the excel file.

Regards
George

The sad story even if you use "fantastic tools" designed by Microsoft eg DTS or SSIS it is still does not work.
Only alternative is to use delimited files with them

My suggestion do not use ODBC or Jet to load data from Excel use standard excel data reader from Advanced ETL Processor
It works correctly with excel files all the time.
Once data from Excel is loaded into the database you can do all your SQL manipulations

Mike