I’m new to Toad World, so please correct me if I don’t know all the ropes here!
I’m a SQL Server DBA, but I want to update an Oracle database with data which has been supplied to me on an Excel spreadsheet.
In SQL Server, I import the spreadsheet to an import$ table, update the destination from the import$ table using an inner join, and drop the import$ table.
There is an import utility in Toad, but it seems to only want to import data from another database, not Excel
I could use SQL*Loader, but it’s five years since I did this and I’m less than confident
I could write multiple insert statements using the data and get it in that way, but that’s not very elegant is it?
I’ve had a suggestion that I attach the Excel as an external table - which sounds a bit like what I do in SQL Server, but I don’t know how to do it in Oracle
I would be grateful for advice