SQL-LOADER problem

[charmingcann]

Im going to do importing of data from a legacy system to Oracle ERP using sql loader. Each line in the file consists of columns . Below is a sample data :

!job1
!run batch
500003443 -- part number (3rd line)
711-3434 -- account number (4th line)
25 -- quantity (5th line)
T100 -- trans type (6th line)
-- space (7th line)
700003443 -- part number (8th line)
711-3434 -- account number (9th line)
15 -- quantity (10th line)
T200 -- trans type (11th line)
-- space (12th line)
800003443 -- part number (13th line)
711-3434 -- account number (14th line)
5 -- quantity (15th line)
T100 -- trans type (16th line)

How to do the extraction of this file to load in my Oracle table?

Thanks...

 

[mikewoodhouse]

Did you really mean to post this question in this forum? I doubt that you'll get a great deal of help here.

Consider reposting to the "Oracle ERP Solutions" forum.