Search the web
Sign In
New User? Sign Up
oo4ole · Oracle Objects for OLE (OO4O) Users List
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Oradynaset into MS Access   Message List  
Reply | Forward Message #1590 of 1863 |
Re: Oradynaset into MS Access

--- In oo4ole@yahoogroups.com, "arteaga7" <arteaga7@h...> wrote:
> Greetings
>
> How can I create an MS Access table from an Oradynaset in VBA? An
> Oradynaset is an Oracle Object for OLE (OO4O). I have a VBA module
> that connects and runs a query from Oracle and gets the data into
an
> Oradynaset. Now I need to get this data into an MS Access table.
>
> Thanks
> Sam Arteaga
Hi,

I don' know how to create one neither. However, I use a trick of
appending data to an existing Access table. If you are interested in
it. Let me know. Jeanie :-)




Tue Feb 24, 2004 3:42 pm

jnyh1971
Offline Offline
Send Email Send Email

Forward
Message #1590 of 1863 |
Expand Messages Author Sort by Date

Greetings How can I create an MS Access table from an Oradynaset in VBA? An Oradynaset is an Oracle Object for OLE (OO4O). I have a VBA module that connects...
arteaga7
Offline Send Email
Feb 23, 2004
4:07 am

... an ... Hi, I don' know how to create one neither. However, I use a trick of appending data to an existing Access table. If you are interested in it. Let...
jeanie
jnyh1971
Offline Send Email
Feb 24, 2004
3:43 pm

Maybe using two connection.... like this: ' conn1: connection to OO4O ' conn2: connection to MSAccess ' rs_recordset: the query to OO4O Do while not...
Mario Alejandro Garci...
magaba
Offline Send Email
Feb 24, 2004
6:29 pm

Hi, Yes, I used 2 connections but executing SQL string. I set conn2.rs.field.value = conn1.fields.value in a subloop of field numbers of conn1.rs_recordset...
jeanie nguyen
jnyh1971
Offline Send Email
Feb 24, 2004
7:03 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help