All Forums Analytics
nitinrp 1 post Joined 05/05
17 Nov 2005
EXcel to Teradata

Hi ,I have an Excel file with 1000 records ,i want to get these 1000 records to be loaded in teradata.Does any one know how to get this done and which utility will help me to get the excel file to teradata.plz let me know !!!!!regardsnitin

sachinace 11 posts Joined 09/07
06 Feb 2008

Hi But what in case null values exist in a particular record..I Can see a error saying data value missing...We can insert entire column (all the rows) with null or constant values..But what abt specific null values...Can we insert from csv file if null values exist ?I have atried wih empty value in csv as well as the null clause in csv..

karthikzint86 3 posts Joined 04/08
21 Apr 2008

can anyone provide the MLOAD script for the same??? I have a script I can compare with it... and post a modified one...

Phani 15 posts Joined 07/04
02 May 2008

If you have access to oleload tool, you can use that. You can import from access directly. To import from Excel, you need to modify the connection properties of Microsoft Jet 4.0 OLE DB Provider to import from Excel. This method helps to map columns and their types automatically.

Kevin Liu 3 posts Joined 06/05
14 May 2008

Detailed information on using OleLoad to transfer a spreadsheet into Teradata is available at http://www.teradataforum.com/teradata/20040130_185317.htm

You must sign in to leave a comment.