CODEWITHSUNDEEP
sqlplsqloracle-sqldeveloperapex-data-loader
Gayathri
Gayathri

Reputation: 349

How to automate an Excel data sheet to be loaded in the SQL developer?

We get daily data in Excel files and I want to load that Excel sheet data into the database on a daily basis.

I want that Excel sheet data to be loaded automatically into the database.

How can I set auto-load for this? I am using SQL Developer.

Upvotes: 2

Views: 3505

Answers (1)

AdamRossWalker
AdamRossWalker

Reputation: 314

One way to solve this is to write an Excel macro in VBA. Saving to CSV first is risky in my experience as data like telephone numbers (represented as text) lose the leading zeros. Furthermore, UK/US date formats can get misinterpreted.

The macro can load source files from a directory, validate the spreadsheet in its native format and then push insert statements to the database or call a stored procedure.

The only downside is someone needs to open and run the macro, however this can be automated if desired: How can you run an Excel macro through a schedule task.

Upvotes: 1

Related Questions