Archives of the TeradataForum

Message Posted: Tue, 20 Oct 2010 @ 00:59:16 GMT

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

Hi,

I would go for OLE-Load instead of SQL Assistant. Define a = ODBC-Connection to your Excel sheet and then define a job within OLE-Load -> works perfect...

If you save your Excel as a tab delimited text file, you will face ( at least I faced ) problems with some nice "soft carriage returns" which destroy the data structure.

For export: Use SQL-Assistant and save as html. You can easily load the = html to Excel afterwards.

Just my 2 cents ...

BR

Christian

D.I. Christian Schiefer

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