Home » Infrastructure » Windows » Create MS Access Table from an Oradynaset (OO4O)
Create MS Access Table from an Oradynaset (OO4O) [message #100931] Mon, 23 February 2004 11:51 Go to next message
Sam Arteaga
Messages: 1
Registered: February 2004
Junior Member
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

Report message to a moderator

Re: Create MS Access Table from an Oradynaset (OO4O) [message #100975 is a reply to message #100931] Tue, 09 March 2004 10:15 Go to previous message
ilver
Messages: 50
Registered: January 2004
Member
Hi,

Having a dynaset you should know the table layout/recordformat.
Then create the table.
Then go through the dynaset inserting the rows.
Commit the inserts.

/ilver

Report message to a moderator

Previous Topic: Reg. Oracle 9i Installation hanging
Next Topic: Determining Version of Oracle 9i AS on Windows 20
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 13:32:33 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.