Re: Getting data via ODBC

Never done it that way round, on the grounds that it's probably horrendously difficult (await response from others on the lines of 'No it's not').

I'f be interested to hear how it's done if you ever find out!

Sorry I can't be of any help.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"Mark Styles" <news_at_lambic.co.uk> wrote in message
news:n51pvsklrt0m21kltkp2lu2rognmhkgpqq_at_4ax.com...


> On Sun, 29 Oct 2000 16:03:27 +1100, "Howard J. Rogers"

> <howardjr_at_www.com> wrote:

>

> >Access 2000 (and allegedly it hasn't changed much since 95):

> >

> >Assuming you have data in Access that you want to get into an Oracle

> >backend, highlight a table, click File - Export, and in the ensuing

 dialogue


> >box, select for files of type 'ODBC databases'.

> <snip lots of good info>

>

> Thanks for that, but actually I'm trying to find a way to do it the

> other way around. I.e. I want to make an ODBC call TO Access FROM

> Oracle, ideally automatically, and even more ideally in a stored

> procedure (but this might be asking too much!).

>

> >You are indeed a brave soul if you are going to try this with Lotus

 Notes.


> >I guess the whole concept of ODBC suggests that it should all work much

 the


> >same, but I don't rate your chances for total sanity at the end of a week

 of


> >trying!

>

> My sanity is already in question, I hate bloated goats with a passion!

>