Loading from a .txt file using OLE load


Loading from a .txt file using OLE load

I have a .txt file that has data in the following format.


I want to use OLELOAD to load my table.How shoud I go about it?

Re: Loading from a .txt file using OLE load


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


Re: Loading from a .txt file using OLE load

How to load a Teradata table from a custom delimited text file using
the OleLoad program that is included in the Teradata OLE DB Access
Module (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:
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.