How to get data from Excel to Teradata table without using teradata olap connector

Database
Fan

How to get data from Excel to Teradata table without using teradata olap connector

Hi ,

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?

Tags (2)
5 REPLIES
Enthusiast

Re: How to get data from Excel to Teradata table without using teradata olap connector

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. 

Khurram
Fan

Re: How to get data from Excel to Teradata table without using teradata olap connector

Wanted to reduce the time and manual work... So wanted to know if theres a way to do this, Thanks.

Enthusiast

Re: How to get data from Excel to Teradata table without using teradata olap connector

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.

Fan

Re: How to get data from Excel to Teradata table without using teradata olap connector

Thanks for the info...

Any idea from where we can download teradata OLAP connector?

Enthusiast

Re: How to get data from Excel to Teradata table without using 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.