By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,991 Members | 1,887 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,991 IT Pros & Developers. It's quick & easy.

import data into Orace from Access

P: n/a
How do I import data from Access into an Oracle database? I'm looking
at hetergeneous services but I was hoping to simply set up an ODBC
connection and pull accross the data easily. But I cannot find any
apparent easy way to do this.

Aug 4 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
oracle people must do this all the time...

Why not ask in a oracle newsgroup? They must have solutions for this on a
daily basis...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Aug 4 '06 #2

P: n/a
co**********@gmail.com wrote:
How do I import data from Access into an Oracle database? I'm looking
at hetergeneous services but I was hoping to simply set up an ODBC
connection and pull accross the data easily. But I cannot find any
apparent easy way to do this.
I'm afraid I have no idea what "heterogeneous services" means, but have
you tried linking tables and simply running an append query? If you
have a properly set up Oracle table, this shouldn't be a problem.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Aug 5 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.