Re: Insert into an Oracle DB from Excel - how?

jaakola_at_cc.helsinki.fi wrote:

>I want to insert records into an Oracle database from Excel 5.0. What
>possibilities exist to do that?
>--
>Juhani Jaakola, jaakola_at_cc.helsinki.fi

Juhani,

We have code called SQLGlue .90 that will greatly simplify such a task. My company is preparing it for release as shareware. We have been using it since 92' for our own internal and customer projects.

What is it?

• It is a Windows toolkit.
• It is a dynamic SQL Method 4 engine.
• No precompliers, no EXEC SQL, and NO OCI.
• It allows you execute SQL from ANY Windows application that can CUT/PASTE. Coolest..
• Multiple desktop applications can send/receive SQL.
• You can develop killer apps in any language. How? The engine processes string text. So you don't need to do all that SQL crap like ODBC, Embedded SQL, or Object stuff. All you do is build a SQL string and send it to the SQLGlue engine.
• Enough -- I can get carried away. It has made my life as an Oracle applications developer far easier and very productive. I no longer think SQL API's.

We are putting together the documentation and cleaning up some sample apps -- one sample is an Excel 5.0 Workspace with several sheets. One sheet queries the primary tablespaces and displays a table and chart!

I have built production document-imaging applications with this tool for several Fortune 500's. This first release was designed for transaction environments -- small result sets, although you can still dump an entire db of unlimited size. You just have to pull out your rows in a manageable size.

If this is the kind of tool you would like to have. I would be more than happy see you receive it as soon as we release it.

When will that be?
Well, the powers that be have us knee deep in everything from JAVA to Perl and then some. Our last target date was the end of Feb. 96.

I may be able to provide you with an early release, if you need it ASAP.

Mark         

                       !!!!!
                      /'_at_ @'\

|   BigDaddy's Internet USENET FaxBack Service    |
|         'never leave home without it'           |
|                                                 |
| Mark Otero                        mpower_at_ee.net |
| MPower                        Your Future Today |
| 178 Beechbank Road               (614) 338-1550 |
| Columbus, Ohio 43213-1261    Fax (614) 338-1553 |
+-------------------------------------------------+
                     | |  | |
                    {__|  |__}