# Data upload from excel to Database **URL:** \ **Category:** Ignition\ **Tags:** ignition79\ **Created:** [January 5, 2021, 9:31am UTC](https://forum.inductiveautomation.com/t/data-upload-from-excel-to-database/41968 "2021-01-05T09:31:34Z")\ **Posts on this page:** 1\ **Showing post:** 8
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [January 5, 2021, 10:41am UTC](https://forum.inductiveautomation.com/t/data-upload-from-excel-to-database/41968/8 "2021-01-05T10:41:07Z")
> [@Python script optomisation](http://forum.inductiveautomation.com/t/python-script-optomisation/11274/18): > > So seems to be that this line; multiRowPrepUpdate is the cause. Running it in the script console, or on a gateway event, won’t write anything to the db. It will on an action performed button in a client for some reason. I could change this to system.db.runPrepUpdate, as my script in the 1st post does execute and write to the db, but then I’d be back to my original issue once I exceed 30k entries, and also the filepath error. So I tried the store and forward suggestion, and also combining the … --- _[View the full topic](https://forum.inductiveautomation.com/t/data-upload-from-excel-to-database/41968)._