APEX

I have migrating an Access application to ApEx. I ran the Download Exporter for Microsoft Access and have chosen the Export Table Data option. That results in a xxx.dat file for each table in the Access db. After migrating the Access database into Oracle via SQL Developer's Migration Manager I don't know how to load the tables using the generated .dat files. I found a place in documentation that says to load them via SQL Loader, but that utility doesn't seem to know what to do with them.

When I look at them via NotePad they look like this example:
Cargo Van<EOFD>Econoline<EOFD>80<EOFD>5/20/2003 1:52:10<EOFD>msaccdba<EOFD><EORD>

I recognize that <EOFD> indicates End of Field Data and <EORD> apparently is End of Record Data, but I sure don't see a way to get SQL Loader to recognize that.

I am using the SQL Loader wizard in TOAD, and it may be that I don't get all the options the real SQL Loader would have given me.

Any advice from someone who has loaded the generated data .dat files will be appreciated. I am very new at ApEx and even at using SQL Loader.

Thanks,
Tom Kruse
Applications Development
IPFW (Indiana University Purdue University Fort Wayne)