All Forums Tools
Tifosi 2 posts Joined 02/05
02 Mar 2006
Loading from a .txt file using OLE load

Hi,I have a .txt file that has data in the following format. "NAME"|"PLACE"|"LOCATION"I want to use OLELOAD to load my table.How shoud I go about it?

ANGEL 20 posts Joined 02/05
03 Mar 2006

Hi,It has a graphical interface where you can just select the source database and its columns and then select the target where you want to load the tables .Once you are done with that, just tell it how you want to proceed whther you want to use fastload,mload aor bteq.and presto it will generate the script for you .you can make some modifications to suit your needs and that will do your job.See the folowing link 01/30/2004 (Fri) Re: Teradata <--> Excel transfers via OleLoad Shawn Shealy Attachment: .rtf (37kb) save as: OLDBXCEL.rtf Hope this helps!!Angel

Kevin Liu 3 posts Joined 06/05
06 Mar 2006

How to load a Teradata table from a custom delimited text file usingthe OleLoad program that is included in the Teradata OLE DB AccessModule (just the interesting steps):- Create a new file. This new file must be named schema.ini and must be placed in the same folder as the input file. This new file must contain the following: [filename] Format=Delimited(|) In this, replace “filename” with the name of the input file without the folder part (for example, MyInfile.txt), and replace the "|" with the delimiter used between values in the input file.- In the OleLoad GUI, for "Select a source", choose the "Microsoft Jet 4.0 OLE DB Provider (Microsoft.Jet.OLEDB.4.0)" entry.- On the "All" tab of the "Data Link Properties" dialog box, set "Extended Properties" to "text" (without the quotes) and set "Data Source" to the pathname of the folder containing your input file (for example, C:\WINNT\Profiles\JohnDoe\My Documents). - Note that when you close the Data Link Properties dialog box, you will see an error message saying: Error occurred while attempting to set the properties you entered. To make changes and try again, click Cancel. To accept this error and continue, click OK. Failed Properties: Persist Security Info (NOT SUPPORTED) This is normal, just click OK.- For "Select a destination", choose the "NCR Teradata (“Teradata”)" entry.- Ensure that your load script does not utilize row sizes that are too long and does not utilize field names that are objectionable to the load utility.

You must sign in to leave a comment.