Help needed in bteq script to load data into a teradata table from an excel sheet

Tools & Utilities

Help needed in bteq script to load data into a teradata table from an excel sheet

Hi,

I have to load data into a teradata table from an excel sheet located on my local PC through a bteq script.

Please help me in this regard.

Thanks!
1 REPLY
Teradata Employee

Re: Help needed in bteq script to load data into a teradata table from an excel sheet

Hello,

Few of the possible options can be as follows:

- Save excel file as CSV file
- Use that file as source in fastload script and load the data

or

- Using string functions in excel, create INSERT statements for each row
- Save those INSERT statements as SQL script and use BTEQ to execute it

HTH.

Regards,

Adeel