Excel to Oracle data loading

From: Sarabjeet Singh <sarab_at_pop.jaring.my>
Date: 1997/08/03
Message-ID: <01bc9fd2$a91f98a0$ee03a8c0@w238srs>#1/1

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.

Run script to convert excel file into fixed column width text file.
FTP text data file to unix server
create SQL-Load control file using a script that generates the file by querying the database
run SQL-Load to upload test data into database tables.

This whole process is a pain in the rear 'cos it takes a while especially if we have a quick fix like if a table has a new column in it, etc. What I'm looking for is a way to load my data in excel on Win 95 straight to Oracle on our unix server. Any suggestions??? I'd like to keep the master data in excel format.

Cheers Received on Sun Aug 03 1997 - 00:00:00 CDT