Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: How to store an Excel file in Teradata???
 
From:   Ken Hansen

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016