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
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
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
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)
EXCELLENT !!! TOAD to the rescue again!
Thanks John