|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/18/2005 4:54:00 AM
Posts: 5,
Visits: 1
|
|
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
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/15/2008 2:26:00 AM
Posts: 6,
Visits: 11
|
|
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..
<
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/1/2008 10:10:01 PM
Posts: 2,
Visits: 5
|
|
can anyone provide the MLOAD script for the same??? I have a script I can compare with it... and post a modified one...
Regards,
K.karthik
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 5/2/2008 2:28:55 AM
Posts: 15,
Visits: 2
|
|
|
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.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/14/2008 9:42:48 AM
Posts: 6,
Visits: 2
|
|
Detailed information on using OleLoad to transfer a spreadsheet into Teradata is available at http://www.teradataforum.com/teradata/20040130_185317.htm
|
|
|
|