InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 20 Nov 2008 11:06:24 GMT20http://www.teradata.com/teradataforum/Topic9960-5-1.aspxHi,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,24101,s2,18Query :Insert into student(?,?,?);Follow this method if the number of rows are very less.Thu, 08 May 2008 05:39:53 GMTsathiyamurthyhttp://www.teradata.com/teradataforum/Topic9960-5-1.aspxHi 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 Access4. Import Data using Queryman .. (File-Import data, and then a single insert statement with your variables .. )Hope this and other responses help you .. Thanks ..Thu, 13 Dec 2007 13:21:10 GMTJohn Abrahamhttp://www.teradata.com/teradataforum/Topic9960-5-1.aspxThere are quite a few posts on this topic. Please search the forum with key word 'import'.Wed, 05 Dec 2007 12:43:38 GMTSomeshhttp://www.teradata.com/teradataforum/Topic9960-5-1.aspxHi all,I need to import data from Excel file in Teradata.Can you help me?Thanks,AnthonyTue, 04 Dec 2007 20:48:19 GMTmilulove04