Withdata Software

Fix bug on loading multiple Excel sheets to database at once

An email from a user of OraLoader:

“I´m using the functionality xls(All sheets) and the values in oracle table are allways the sheet 1 repeted n.sheets .
I include 2 columns to the xls file (sheet,consecutive) and never charge to oracle table the sheet 2, even when I count the table and the rows number of inserted data is ok.”

This bug is caused by OraLoader can not read the 2nd sheet when read the 1st sheet to the end, it read 1st repeatly.

This bug is fixed.

These softwares have the same bug, and are fixed now: XlsToMdb,  XlsToDB2,  XlsToMy,  XlsToSql,  XlsToOra.