Archives of the TeradataForum

Message Posted: Tue, 26 Feb 2002 @ 12:19:07 GMT

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

Why would you want to store excel files in a single column on Teradata? What you can do is store a spreadsheet as a table and this might be loaded directly by users either using SQL "create table" & "Insert..... values" or using ODBC. Multiple spreadsheets of the same format could be stored in a single table by adding the spreadsheet identifier as an extra column. NB you may run into data quality problems as Excel will accept numbers or characters and does not truncate long strings whereas Teradata tables require you to specify data type and length per column. Tell us more about what you want to achieve.

Ken Hansen
Ivy House Associates

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