excel to oracle bulk insert/update
484523Jan 23 2006 — edited Jun 3 2010Maybe someone can point me in the right direction:
I have a large amount of data within an excel spreadsheet, and i want to select it all, and update a table in an oracle database with the data. Some will be inserts, some will be updates. I know how to select the excel data into an ado recordset, but how do I pass the data to oracle?
The connection is very slow - is there some way to pass oracle an entire recordset, or some other form of bulk data? I can then loop through the records within the stored proc and perform the inserts/updates there.
Thank you