Archives of the TeradataForum

Message Posted: Fri, 29 Jan 2010 @ 09:24:00 GMT

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

Hi All

I'm trying to import data into Teradata from an excel worksheet using SQL.

I've been trying to use the following:

     insert into DATABASE.TABLEvalues (?,?,?);

using the Import data option I direct Teradata to the spreadsheet with 3 columns of data (as defined above), but get the following error:

'Wrong number of data values in Import File' - Though there is definetly only 3 columns of data.

Anyone had this issue before?

Paul Graham

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