MS Excel data into Oracle on Unix DB [message #367045] |
Wed, 06 September 2000 06:58 |
Claire Nash
Messages: 2 Registered: September 2000
|
Junior Member |
|
|
What middleware are people using in order to load data from an Excel spreadsheet (on NT) into an Oracle database on Unix? We are currently migrating our warehouse to Unix and the old ODBC driver does not work as it is NT only. Any recommendations?
Thanks
Claire
|
|
|
|
Re: MS Excel data into Oracle on Unix DB [message #367094 is a reply to message #367093] |
Wed, 15 November 2000 11:13 |
Claire Nash
Messages: 2 Registered: September 2000
|
Junior Member |
|
|
Thanks for your comments. We resolved this by creating the tables in our Oracle warehouse then linking to them via MSAccess. The business users who maintained this spreadsheet like data still get their data in a similar format and the data is written straight to the database. Fortunately, this small group of users already had Access and we just administer the passwords and permissions.
|
|
|
|