Re: SQL*Loader with dbase files

Eric,
A quick and standardised solution for you would be to use a transfer and replication product called SQLMover. Just point your dBase ODBC driver to your dBase database files and your Intersolv Oracle ODBC driver to the Oracle database and you are on your way. The dBase driver is included in the MS ODBC desktop driver set and can be downloaded together with SQLMover from http://www.sqlmover.com. The Oracle Intersolv ODBC driver is included in Intersolvs DataDirect package and can be downloaded from http://www.intersolv.com. SQLMover migrates/converts/replicates between all ODBC compliant databases. To evaluate SQLMover this month use the key 1JHHYDOHG.
SQLMover uses a simple or complex SELECT statement towards your datasource and a INSERT, UPDATE, INSERT and UPDATE or DELETE statement towards the destination table. SQLMover has a built in schedule engine and provides extensive error logging capabilities. If you want to change datatypes when transferring/replicating SQLMover provides implicit conversion, if you want to you can also apply conversion statement in your SELECT query (or string functions for concatenation and splits, mathematical and date/time functions) or by using the built in format mask wizard. For very complex cleaning and conversion operations you will always have the choice of introducing an intermediate desktop or low cost DB like personal Oracle or SQL Server workstation. Also - if you are into Data Warehousing - check the News page at http://www.sqlmover.com.
Regards,
Peder Holst Received on Wed Nov 26 1997 - 00:00:00 CET