Import data from Excel

Database
Enthusiast

Import data from Excel

Iam having data in Excel file..can we load it using sql assistant...if we can do we have to change delimiters in excel also..
3 REPLIES

Re: Import data from Excel

Hi,

You can load teradata table with Source File Excel (Delimited CSV format using SQL Assistant.

1.Save excel data file in CSV format.
2.In sql Assistnat Use File-->Import Data
3.You can write query as
insert into Database.Table (?,?,....).
Where question mark indicates column values.

I hope this will help.

Thanks
Ashwini

Enthusiast

Re: Import data from Excel

Something to say? Add your comment here.
Enthusiast

Re: Import data from Excel

yes this would help me ..thanks ashwini