Re: From oracle to MS access through VB5

From: Arthur <a.cheung2_at_sympatico.ca>
Date: Wed, 21 Feb 2001 03:46:43 GMT
Message-ID: <3A933A0A.C0978CD6_at_sympatico.ca>


Hi Stephen,

I am using Oracle Objects for OLE (OO4O), example http://infoboerse.doag.de/mirror/frank/faqoo4o.htm#CONNECT

create a oracle dynaset "Set OraDynaset = OraDatabase.DbCreateDynaset("select empno, ename from emp", 0&)".

and try to save the data to local MS Access table.

But I can't use ODBC driver.

That's why I try to loop through the dynaset and insert data one by one into MS Access in VB5.

But this method is too slow. Any Suggestions?

Thanks,

Arthur

Stephen Goguen wrote:
>
> 1. Use ODBC to link to Oracle...
> A. Select File | Get External Data | Link Tables
> B. When you see the Dialog Box to select a file, click on
> the combo box below labeled Files of Type and Select ODBC.
> C. From there it will allow you to choose an ODBC Datasource.
> 2. Take advantage of SQL to do the looping for you.
>
> INSERT AccessTable
> SELECT [Columns]
> FROM OracleTable
> WHERE [Yada yada yada]
>
> If that doesn't fit the bill, I can probably suggest more options.
>
> Also, if that solution isn't good enough, tell us which technologies
> you're using. DAO, RDO, ADO, etc.
>
> Steve
>
> PS, A Dynaset is slow looping through. I would suggest you open
> it as a snapshot with a forward only cursor. An even quicker
> method is to use GetRows which loads X or all of the records into
> a Variant Array. However, you're still going to have insert them
> manually, either using .Add function or an "INSERT" statement.
>
> > I need to save/transport the content of a VB5 "oracle dynaset object" to
> > MS Access in VB5.
> >
> > Looping through the result set
> > and do insert to each record is too slow.
> >
> > What are the fast ways of doing it.
> >
> > Thanks,
> >
> > Arthur
Received on Wed Feb 21 2001 - 04:46:43 CET

Original text of this message