Skip to Content
0
Former Member
Feb 16, 2011 at 02:00 PM

Excel ODBC - wrong data type of each column

223 Views

While trying to load Excel files, by default BobJ will consider first 8 rows to determine the data type of each column.

So, cases where the first 8-10 rows have empty data, the data type selected by BobJ may not be correct and we may face problems with uploading/transforming the data in these columns.

I know we can resolve this issue by adding "IMEX=1; MAXROWSTOSCAN=0" in the connection string of an ODBC but I didn't find any ODBC connection in BobJ.

Any ideas on the above people?

P.S. I have around 50 Excel Workbooks in my job.

Source: [http://support.microsoft.com/kb/189897/en-us|http://support.microsoft.com/kb/189897/en-us]