How to import data from Excel file

Analytics

How to import data from Excel file

Hi all,

I need to import data from Excel file in Teradata.
Can you help me?

Thanks,
Anthony
5 REPLIES
Enthusiast

Re: How to import data from Excel file

There are quite a few posts on this topic. Please search the forum with key word 'import'.
Enthusiast

Re: How to import data from Excel file

Hi Anthony ..

Here is what I found quite easy to do ..

1. Import the spreadsheet into an Access Database. You can do this very easily, no complications.
2. Export from Access to a text file with .csv and a set delimiter.
3. In Queryman, set the delimiter to what you exported with in Access
4. Import Data using Queryman .. (File-Import data, and then a single insert statement with your variables .. )

Hope this and other responses help you .. Thanks ..

Re: How to import data from Excel file

Hi,

Try this.

1)Save the file as comma delimited file from Excel (CSV File).
2)In SQL Assistant set the Delimiter as ","(comma) . ( Delimiter is available in Menu Tools , Options, Import/Export)
3)In SQL Assistant enable the Import mode(select "Import data" in file menu).
4)Run the query : INSERT INTO table_name(Col1,Col2.....Coln);

Example

DDL :
create table student(
Reg_no integer,
name varchar(20),
Age int)
unique primary index(Reg_no);

Data in File:

100,s1,24
101,s2,18

Query :
Insert into student(?,?,?);

Follow this method if the number of rows are very less.

Teradata Employee

Re: How to import data from Excel file

Hi Sathiyamurthy

I used your suggested method as above and it worked well for 7,000 records (about 90 seconds) 438Kb.

Thanks John L

Re: How to import data from Excel file

I am working on excel for long time. Importing conditional data from another excel is quite easy. you have to follow some simple steps without using vba and by using formula. For this purpose please visit the link below

http://excelguider.blogspot.com/