Home » Infrastructure » Unix » MS Excel data into Oracle on Unix DB
MS Excel data into Oracle on Unix DB [message #367045] Wed, 06 September 2000 06:58 Go to next message
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 #367093 is a reply to message #367045] Wed, 15 November 2000 11:03 Go to previous messageGo to next message
Sivan
Messages: 4
Registered: November 2000
Junior Member
Are you able to connect to ORACLE from your PC thru ODBC then u can write a simple Macro and do the job.
Re: MS Excel data into Oracle on Unix DB [message #367094 is a reply to message #367093] Wed, 15 November 2000 11:13 Go to previous messageGo to next message
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.
Re: MS Excel data into Oracle on Unix DB [message #367095 is a reply to message #367093] Wed, 15 November 2000 11:25 Go to previous message
Sivan
Messages: 4
Registered: November 2000
Junior Member
Exactly... You can do this
Previous Topic: CPU and Patrol
Next Topic: install Oracle 8.1.7
Goto Forum:
  


Current Time: Wed Sep 23 12:16:41 CDT 2020