import from csv to directly teradata table

Database

import from csv to directly teradata table

Hi friends,
Can anyone have the idea "how to import csv data directly into teradata tables?" I am using mload but i want to do it directly from csv to teradata table without using mload etc.
3 REPLIES
Enthusiast

Re: import from csv to directly teradata table

Shishir can u tell how many cols and rows are there ???

Re: import from csv to directly teradata table

There are approx 1000 rows and 10 columns
Enthusiast

Re: import from csv to directly teradata table

If it is a one time thing, you can import from SQL assistant. If this is a task that should be done daily you have to create a MLOAD/FLOAD.

assume the table name is TABLEA

in the sql assistant click on FILE----->IMPORTDATA
and in type this sql

Insert into tableA
(?,?,?,?,?,?,?,?,?,?);

? stands for col's
SQL assistant prompts for a file to import from choose the file name and the import is done.

make sure that in SQL assistant TOOLS---->OPTIONS (EXPORT/IMPORT) tab In IMPORT section
specify the delimeter type and check the box (Ignore first record in the file) as per you file details.
once the load is done click on FILE---->IMPORTDATA to disable this option.

hope this helps.