Home » RDBMS Server » Server Utilities » Transfer data between Oracle and Access 2000 using VB 6
Transfer data between Oracle and Access 2000 using VB 6 [message #121043] Wed, 25 May 2005 09:16 Go to next message
bhadresh4u
Messages: 41
Registered: May 2005
Location: Japan
Member

Hi.

I wants to Transfer my data from Oracle to MS Access 2000 (.MDB) in VB 6 Application & vise-verse. I open two connection each for Oracle and MS Access (i.e. MDB) in VB 6. Now, how can I transfer my data from oracle to MDB. (in Both databse, tables structure are same).


Bhadresh

Report message to a moderator

Re: Transfer data between Oracle and Access 2000 using VB 6 [message #121067 is a reply to message #121043] Wed, 25 May 2005 12:23 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member

Use select queries from oracle & insert queries into access.

Report message to a moderator

Re: Transfer data between Oracle and Access 2000 using VB 6 [message #121077 is a reply to message #121043] Wed, 25 May 2005 16:12 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
This article might help:



Best regards.

Frank

Report message to a moderator

Previous Topic: SQL LOADER error during import some packed value
Next Topic: Use SQL Loader to load CLOB/BLOB data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 07:52:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.