Import Excel to Database Batch Size is not working

Question

Hi, 
 I would like to inform you that I am using Import Excel to Database smart service. I have able to insert data to database successfully but it is always inserting 1000 rows (the default value of Batch Size) though I have set the Batch Size to 40. It is inserting 960 rows extra with 0 or null values along with the valid 40 rows . Can anyone please help me regarding it. Following is the screenshot: 
 
 Is there any link of proper documentation for Import Excel to Database smart service? Can you please share the document link with me?

Mike Schmitt · Answer

I'm not familiar with this one, but I'd like to suggest an alternate approach if you can consider it. Check out the Read Excel Sheet function, also found in the Excel Tools plug-in, which will allow you to read Excel data to a local dictionary (which you can then do data parsing / cleanup on, prior to writing it to your data store).

Import Excel to Database Batch Size is not working

Top Replies