Skip to main content
P
prafulb0002
April 25, 2022
Question

Approach to upload excel sheet data to DB

  • April 25, 2022
  • 4 replies
  • 0 views

I have to upload data(rows) from excel sheet to Db  and maximum number to rows in excel sheet can be 100 rows . What is the best  approach to get this?

4 replies

N
nareshs945
Inspiring
April 25, 2022

Hi,

You can use Import Excel to Database smart service to import data into a temporary staging table first and then use that data to save into associated tables (This will give an option to manipulate or update any data ex: Date Values before saving to actual tables)

P
prafulb0002Author
April 25, 2022

saving 100 rows all at once in db is fine , it will not affect performance ?

gopalk2865
gopalk2865
Participating Frequently
April 26, 2022

No ,it wont impact. I have inserted much more without any performance issues. If you are going to insert heavy data then you would need to design your flow considering performance aspects.

Terms & ConditionsAccessibility statement