Re: SpreadSheet >>> Oracle DB ??

From: Robert Murdock <robert.murdock_at_intelsat.int>
Date: 1995/04/21
Message-ID: <3n8o2r$oe5_at_news.intelsat.int>#1/1

RLPA80_at_email.sps.mot.com (John-Reed Maffeo) wrote:

>

> What is the best way for an individual user to put data
> that is in a spread sheet (Excel, Lotus (Mac, DOS)) into
> an oracle DB running on a remote host?

We have several "solutions" currently deployed to do exactly this for Oracle Financials. The best method we have found is to use ODBC as the connection method to the database and then write a progarm (Visual Basic for Applications) within Excel to handle the formatting and upload of the data. Until version 5.0 of Excel we used Oracle Glue instead of ODBC (Glue is faster), but when we upgraded to Excel 5.0 we moved to ODBC.

You can e-mail me for more details if you desire.

Good luck,
Bob Received on Fri Apr 21 1995 - 00:00:00 CEST