Showing results for 
Search instead for 
Did you mean: 

Insert Excel data to oracle tables using OLEDB

Level 3


I am trying to insert data from an excel file to oracle table using OLEDB.

Since the data in the excel in large count (100000+), the insert fails.

Can someone help me with this ?


Can you also check the work queue is creating your work items correctly and are showing as pending? also check that the criteria you have set for Get Next Item will return a pending item from the queue. The only way I could recreate a similar issue to yours is by setting the criteria on the get next item incorrectly so that the Get Next Item failed.