ETL and Data Integration tools - Modern ETL software for everyone

Hello

I am pulling data from Excel file via ODBC.
Some of the cells are blank but if I open excel file they are not blank.
What is going on?
I have set IMEX to 1, HDR=Yes and TypeGuessRows to 0
Importunately It did not help.

Looking forward to your help.

George.

This famous mixed data types problem

For example:

* In your eight (8) scanned rows, if the column contains five (5) numeric values and three (3) text values, the provider returns five (5) numbers and three (3) null values.
* In your eight (8) scanned rows, if the column contains three (3) numeric values and five (5) text values, the provider returns three (3) null values and five (5) text values.
* In your eight (8) scanned rows, if the column contains four (4) numeric values and four (4) text values, the provider returns four (4) numbers and four (4) null values.

As a result, if your column contains mixed values, your only recourse is to store numeric values in that column as text, and to convert them back to numbers when needed in the client application by using the Visual Basic VAL function or an equivalent.

and there is nothing you can do about it.

All solutions created by Microsoft for loading data from Excel do not work (so far).
That includes DTS, SSIS, ODBC, OleDB, Jet and .Net

My suggestion do not use ODBC or OLE DB to load data from excel

Use Advanced ETL processor. It works correctly with Excel all the time.

Load data into database and than do all sql manipulations there.

Peter

Pulling data from excel no problems found

Doing exactly the same via ODBC

Notice that some blank cells.

Thanks Mike

This certainly seems to load Excel files as a single sheet, but what happens if I want to join two sheets together or a single cell onto the end of each record?

Do I then need to use an Ole DB connection and then have the issues again regarding 255 char length, etc.?

Regards
George

1 Load both of excel sheets into the database and join them there
2 use lookup object

Here is the tutorial
www.dbsoftlab.com/online-tutorials/advan...g-lookup-object.html

Mike