Toad World® Forums

Creating a new table with Excel or Access


#1

Is there any way that TOAD can create a table based on an Excel sheet or an
Access Table?

I know I can import to an existing table, but I’m wondering about having
TOAD do the Oracle table creation….

Jerry


#2

Just go to the create table dialog. Down near the bottom there’s a
“Load Cols from File” button which will create column definition
based on your excel file or access table.

-John


#3

I use data import wizard and on the select target screen, you can just click the
button on the right (A single new table). You can then name the table and
location. Lots of ways to get the same job done in TOAD.

Darlene R. Ulmet

Financial Analyst II

Revenue Cycle

Strategic Financial Planning and Analysis

Baylor Health Care System

Phone: (214) 820-1936

Fax: (214)820-8515

Email: Darlene.Ulmet@BaylorHealth.edu

“It is never too late to become what you might have been.”

George Eliott (Mary Ann “Marian” Evans Lewes Cross)

(1819-1880)


#4

EXCELLENT !!! TOAD to the rescue again!

Thanks John