Archives of the TeradataForum

Message Posted: Wed, 20 Oct 2010 @ 08:59:26 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Just go to Tools menu in SQL Assistant and in Options you will see IMPORT tab, There set the delimiter as TAB for loading data from excel and then you can write down an INSERT statement and get the data loaded..

I can't provide teh snapshot for the same But the example is as below..

After putting the delimiter at IMPORT options you can write down an INSERT statement as below.

supose the table struc is

     CT temp_abc
     (
     eno  inetger,
     ename varchar(10),
     addr  varchar(50)
     )primary index ( eno)
     ;

The insert shuld be written as follow insert into temp_abc (?,?,?); and before executing change the mode to IMPORT and execute the statement.

Hoep it helps..

Thanks,

Vivek

	<Prev	Next>		<<First	<Prev	Next>	Last>>