DBA's

I have the following problem:

I need to import a multi-record type tab delimited file
into a set of Oracle tables based on each record type.

If anyone has done something similar or has any idea how
do import this type of file I will appreciate the help.

The tab delimited file looks like :

101-1joesmith
101-2New Jersey
102-1PaulJones
102-2New York

101 is the employee number -1 and -2 are the record type indicators.

Record type 1 records are loaded into table

emp_names
(emp_num varchar(10),
fname varchar(20),
lname varchar(20))

Record type 2 records are loaded into table

emp_state
(emp_num varchar(10),
state varchar(20),
)


Thanks
Umesh