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
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.
From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]
Sent: Thursday, September 05, 2013 8:26 AM
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
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.