Re: Excel to Oracle data loading

Sarabjeet Singh wrote:
>
> 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.
>
> 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

I believe you can use ODBC to connect Excel and Oracle. Could you not then insert the data from Excel (probably in a macro). While this may be possible I would certainly question your reasons for maintaining the data in an Excel spreadsheet. I mean, what did you buy the database for? You could create a table or tables to hold the data and then use just about any front end tool you want to display the data as it is displayed in Excel.

Chris Halioris
Tactics, Inc. Received on Tue Aug 05 1997 - 00:00:00 CDT