Import csv to teradata table directly

Asked By 30 points N/A Posted on -
qa-featured

import CSV to Teradata table directly idea? CSV to Teradata table without using mload is required. Is it possible?

SHARE
Answered By 0 points N/A #187249

Import csv to teradata table directly

qa-featured

Yes this is possible. Here are the required steps:

  1. The columns in Excel should be in same order as that in Teradata table.
  2. You then need to remove the header row from the table as save the file as comma delimited file in excel.
  3. Now in SQL set the delimiter as comma ",". You will find delimiter in menu tools options import/export.
  4. Go to tools option and change the data format to "yyyy-mm-dd" format. This is required if table contains date field.
  5. From Teradata SQL assistant select 'file' and then import data.
  6. Now run the command Insert into table name values(?,?,?,?);
  7. You need to supply the ? for every column.
  8. Highlight the insert query that you have written and press f5. This will ask for file location and then select the appropriate file location.
  9. This will load in the order in which it is being shown in text file. 
  10. Finally turn off the import data mode and continue querying. You are done.
delimiter-sql-assistant-excel import-to-teradata data-teradata-sqlassistant-teradata-excel

Login/Register to Answer

Related Questions