EXcel to Teradata

Analytics

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 !!!!!

regards
nitin
4 REPLIES
Enthusiast

Re: EXcel to Teradata

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..

Re: EXcel to Teradata

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

Re: EXcel to Teradata

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.

Re: EXcel to Teradata

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