Re: Excel to Oracle data loading

My vote goes to pumping the data directly from Excel into the oracle DB using a simple VBA script and then using either ODBC or OO4O.

 Dr. Blue wrote in article <33E88B75.4905_at_deere.com>...
>You could also use Access as an intermediary depending on your problem.
>...
>Richard
>> >
>> > Currently I'm responsible for the system test data in a large dynamic
>> > project. We define our test data in excel spreadshets and use the
 following
>> > steps to get the data into our Oracle DB.
>> >
>> > 1. Run script to convert excel file into fixed column width text
 file.
>> > 2. FTP text data file to unix server
>> > 3. create SQL-Load control file using a script that generates the file
 by
>> > querying the database
>> > 4. run SQL-Load to upload test data into database tables.
  Received on Thu Aug 07 1997 - 00:00:00 CDT