Create Table from Columns - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer Create Table from Columns

Print Thread

Create Table from Columns #52220 10/06/15 03:53 PM
Joined: Jan 2003 Posts: 16 London, UK R rohanale OP Member
OP rohanale Member R Joined: Jan 2003 Posts: 16 London, UK	Hi, Is it possible to create a new table from the columns in a csv file or Excel file. I have a large comma delimited file with about 100 columns and I am hoping I don't have to create all the columns for the new table manually. Please advise. Thanks Rohan

Re: Create Table from Columns rohanale #52223 10/06/15 07:41 PM
Joined: Jul 2003 Posts: 1,140 Virginia, USA ScottMattes Member
ScottMattes Member Joined: Jul 2003 Posts: 1,140 Virginia, USA	Have you looked at the Text Importer under the Tools menu? Scott Mattes

Re: Create Table from Columns ScottMattes #52224 10/06/15 07:51 PM
Joined: Jul 2003 Posts: 1,140 Virginia, USA ScottMattes Member
ScottMattes Member Joined: Jul 2003 Posts: 1,140 Virginia, USA	From the help file: "If you want to import the text into a new table, press the Create table button. This will invoke the Table Definition Editor with a column definition that matches the configuration." Scott Mattes

Re: Create Table from Columns ScottMattes #52242 10/08/15 09:00 AM
Joined: Jan 2003 Posts: 16 London, UK R rohanale OP Member
OP rohanale Member R Joined: Jan 2003 Posts: 16 London, UK	Great. Got it. Thanks.

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.034s Queries: 14 (0.010s) Memory: 2.5109 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-15 02:54:44 UTC
Valid HTML 5 and Valid CSS