import data into Orace from Access

[connormurphy@gmail.com]

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.

[Albert D. Kallal]

Re: import data into Orace from Access

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
pleaseNOOSpamKa llal@msn.com

[Tim Marshall]

Re: import data into Orace from Access

connormurphy@gm ail.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 "heterogene ous 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