@shyann
To insert Excel rows into a Teradata table, you can follow these steps:
1 2 3 4 5 6 7 |
INSERT INTO YourTeradataTable SELECT * FROM dbc.SysExecSQL(' INSERT INTO YourTeradataTable SELECT * FROM YourCSVFile.csv; '); |
Replace YourTeradataTable
with the name of the Teradata table you want to insert the data into, and YourCSVFile.csv
with the path to your CSV file.
Note: Make sure that the structure of your CSV file matches the structure of your Teradata table (same number of columns and data types). Also, ensure that the file path is accessible by the Teradata server.