Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have created an ODBC connection to fetch the multi sheet excel file. The file originally contains 131 sheets. when i am loading it is showing 262(just double) tables (every sheet is duplicated by a name as originalname with an underscore follwed). I think its a driver problem. Any idea ?
your inputs are most welcome.
Thanks & regards,
tresesco
Hello,
Is it possible you don't want to concatenate tables but you are not setting a table name so it takes the previous table name +1? Do the tables have to concatenate? Are you loading using any loop form?
Regards
Hi Baeyens, thanks for your reply.
Yes need to do that. But before i go to load the sheets using the following code gives me the erroneous out put:
ODBC CONNECT TO [fxls;DBQ=D:\....
XLtable:
SQLtables;
DISCONNECT;
let tt=NoOfRows('XLtable');
trace $(tt); // this one is showing me the count double(no of rows)
...tresesco
Hi,
What ODBC driver are you using? I'm reading here office 2007 files with Office 2003 ODBC and returns the right number of tables. (A few sheets, though)