Toad World® Forums

How do I read in data from an Excel Spreadsheet?


#1

Hi!

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

Regards

Jack


#2

Right-click on the table in the schema browser and choose “Import Data”. That will take you to a window where you can choose from several different file
types, including excel. It should be pretty self-explanatory.

From: Jack_Whittaker [mailto:bounce-Jack_Whittaker@toadworld.com]

Sent: Wednesday, February 11, 2015 4:19 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] How do I read in data from an Excel Spreadsheet?

How do I read in data from an Excel Spreadsheet?

Thread created by Jack_Whittaker

Hi!

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

Regards

Jack

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.