Home » RDBMS Server » Server Administration » Is it possible?
Is it possible? [message #58852] Sat, 04 October 2003 22:32 Go to next message
Kapil
Messages: 145
Registered: May 2002
Senior Member
Is there any way that i can create a data base link to MS Access 2000, Well like...
Create table tab1 as select * from tab2@dblink.com
where dblink is to connect MS Access 2000 table tab2.
.. if it is possible.. i would like to know how to create that db-link to Access 2000.
info: using 8i.

Report message to a moderator

Re: Is it possible? [message #58853 is a reply to message #58852] Mon, 06 October 2003 01:38 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Search the board for ODBC or OLEDB. Or else you could look at otn.oracle.com. Go to "technology centers". There's a link to "Windows related" issues. Or you could ask Tom. The Oracle Online documentation can be found at: http://tahiti.oracle.com. And search the site for ODBC or OLE DB. Both OTN and the docs require the same (free) subscription. No strings attached.

Good Luck,
MHE

BTW: Access? Isn't that a little bit "light" in combination with Oracle?

Report message to a moderator

Re: Is it possible? [message #58860 is a reply to message #58853] Tue, 07 October 2003 00:45 Go to previous message
shashi
Messages: 34
Registered: March 2001
Member
You can use sqlservers DTS package to load data from other dbms r rdbms to oracle or from oracle to other RDBMS like mysql,sqlserver msaccess,you can try this option also,hope it helps u

Report message to a moderator

Previous Topic: Domain problem
Next Topic: about 9i migration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:26:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.