Toad World® Forums

Import TXT through Code

Is it possible to import a txt file through code:
Is it also possible to create new columns and assign data within the code?

Use this in the create table window:

Then to do the Import: From main menu: Database -> Import -> Import Table Data.

Thank you for your response. But i was hoping to find a way that takes less steps in such a way that it's automated

The data import can be automated, but the table creation can not, because it likely involves some human interaction to get the datatypes right when creating the columns.