|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/10/2008 2:21:18 AM
Posts: 1,
Visits: 10
|
|
Hi all,
I need to import data from Excel file in Teradata.
Can you help me?
Thanks,
Anthony
|
|
|
|
|
Forum Guru
Group: Forum Members
Last Login: 8/26/2008 4:53:36 PM
Posts: 50,
Visits: 220
|
|
|
There are quite a few posts on this topic. Please search the forum with key word 'import'.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 2/29/2008 4:40:14 PM
Posts: 10,
Visits: 6
|
|
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 ..
Regards .. John Abraham ..
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/8/2008 6:56:41 AM
Posts: 1,
Visits: 8
|
|
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.
|
|
|
|