InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 06 Sep 2008 21:06:42 GMT20http://www.teradata.com/teradataforum/Topic2974-5-1.aspxDetailed information on using OleLoad to transfer a spreadsheet into Teradata is available at http://www.teradataforum.com/teradata/20040130_185317.htmWed, 14 May 2008 09:44:12 GMTKevin Liuhttp://www.teradata.com/teradataforum/Topic2974-5-1.aspxIf 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.Fri, 02 May 2008 02:37:49 GMTPhanihttp://www.teradata.com/teradataforum/Topic2974-5-1.aspxcan anyone provide the MLOAD script for the same??? I have a script I can compare with it... and post a modified one...Mon, 21 Apr 2008 05:07:29 GMTkarthikzint86http://www.teradata.com/teradataforum/Topic2974-5-1.aspxHi 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..Wed, 06 Feb 2008 02:31:26 GMTthelittlechamphttp://www.teradata.com/teradataforum/Topic2974-5-1.aspxHi ,<br><br>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.<br><br>plz let me know !!!!!<br><br><br>regards<br>nitin Thu, 17 Nov 2005 00:03:54 GMTnitinpatil