My requirement is : I have to insert data from excel sheet to teradata tabels without using olap connector and import/export option thats available in TD.
Is this possible, if so could you please help on this?
If you are thinking about a way we used to do in Oracle to directly copy and paste the excel data into table using PL_SQL developer,
I doubt the SQL Assistant do not provide any such facilty yet. the simplext option available is to use SQL Assistant import/export option.
Wanted to reduce the time and manual work... So wanted to know if theres a way to do this, Thanks.
Try the following:
1. Save your spreadsheet as tab delimited
2. Open up SQLA
3. Navigate to File and select 'Import Data'
4. Compose something similare to:
insert into databasename.tablename values (?,?,?,?,?); <== however many columns are in the table and spreadsheet
5. Execute the query
6. Navigate to the location where the tab delimited file is stored.
7. Select the file and the table will be loaded from the file.
Thanks for the info...
Any idea from where we can download teradata OLAP connector?
Can we import data from excel using a query in SQL assistant?
I need to create a stored procedure or macro that can import data from an excel file that is updated every month. Can not do it from GUI everytime, Need to have it as a query saved as a stored procedure or macro.