Toad World® Forums

how to create a table from a spreadsheet

Is there a quick way to craete a tabkle from a spreadsheet keeping the headers as column names?

From the main menu:

Database -> Create -> Table.

On the bottom of the “create table” dialog, there is a button labeled “load cols from file”. There you can specify your spreadsheet and it should build columns
based on that.

Then if you want to import the data afterwards, rt-click on the new table in the schema browser and choose “import data”

From: spike_609 [mailto:bounce-spike2013@toadworld.com]

Sent: Thursday, September 05, 2013 8:07 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] how to create a table from a spreadsheet

how to create a table from a spreadsheet

Thread created by spike_609

Is there a quick way to craete a tabkle from a spreadsheet keeping the headers as column names?

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.

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/03/29/create-and-load-oracle-tables-from-excel-spreadsheet-using-toad.aspx

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, September 05, 2013 8:26 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] how to create a table from a spreadsheet

RE: how to create a table from a spreadsheet

Reply by John Dorlon

From the main menu:

Database -> Create -> Table.

On the bottom of the “create table” dialog, there is a button labeled “load cols from file”. There you can specify your spreadsheet and it should build columns
based on that.

Then if you want to import the data afterwards, rt-click on the new table in the schema browser and choose “import data”

From: spike_609 [mailto:bounce-spike2013@toadworld.com]

Sent: Thursday, September 05, 2013 8:07 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] how to create a table from a spreadsheet

how
to create a table from a spreadsheet

Thread created by spike_609

Is there a quick way to craete a tabkle from a spreadsheet keeping the headers as column names?

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.

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.

Thanks guys - got it now.