Guidelines on Importing Excel Data to Toad

Asked By omor bablu 0 points N/A Posted on - 12/14/2012

Recently I have faced some problem to import my excel data to toad.

I have no idea about that.

Could you give me a details guideline how to I import excel data to toad?

• Status: Open
• Question Views: 938
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: dBase

Best Answer by Johnstoon Leen

Go To Solution

Best Answer

Best Answer

Answered By Johnstoon Leen 0 points N/A #169242

Guidelines on Importing Excel Data to Toad

Hi Omor Bablu

There are multiple methods to import data from excel to toad.

Method 1

1. First the table should exist with the same number of columns as in excel sheet then in toad.
2. Select the proper schema and table name where data should be inserted.
3. Now click “EXECUTIVE WIZARD” where you can specify the type of data file which you’ll import.
4. Now select Excel file (.xls) and click next.
5. Give the path of file then click next and again click on execute.
6. Your data will be imported to toad.

Method 2

1. Create an excel file (.xls) and upload all tables and columns of specific data types
2. Load the file using “SQL LOADER WIZARD” under the database administrator tab of Toad.

Method 3

1. In this way you can import the spreadsheet directly using an IMPORT under the database tab.

I hope you’ll found a better solution from here. Good Luck

Regards,

Johnstoon Leen

About Johnstoon Leen

Questions
4

Answers
102

Best Answers
64

• Vote Up 0 Vote Down

• Posted on - 01/18/2013
• Question Category: dBase

Answered By Shifflett Laurel 0 points N/A #169243

Guidelines on Importing Excel Data to Toad

Hellow Babu,

You can import excel data into to do by following procedures:

• Explore Data import Wizard
• Select File format from input file Format as Excel file
• Checks "Column names as header"
• give the number of rows.
• Brows the location and select the files
• Click the Next Button
• Click the Next Button
• You can see the preview of imported excel file
• Click the Next Button
• Finish

 

 

I hope this will be effective.

Thanking you.

Shifflett Laurel

 

About Shifflett Laurel

Questions
2

Answers
154

Best Answers
78

• Vote Up 0 Vote Down

• Posted on - 01/20/2013
• Question Category: dBase