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]