I am unable to cut and paste from Excel spreadsheet directly into Oracle table (4276003)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

I am unable to cut and paste from Excel spreadsheet directly into Oracle table
Description

I am unable to cut and paste from Excel spreadsheet directly into Oralce table.
I would like to do a multi-row insert for mulitple rows of data.
Resolution

One cannot simply copy and paste Excel data cells into a Oracle database. This is not allowed within the Oracle RDMS.
Use the Import Table Data feature within Toad for Oracle. (Database | Import | Import Table Data.)

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title