Re: Getting data via ODBC

I'm also about to look into which options exists for accessing an Access database >from< the Oracle server side.

As far as I know, Access makes data available only through filesystem type calls, not through network/IP. Then you would need some type of networked drive for the database file and a unix ODBC driver for Access, I guess.

Other way around, pushing the data from Access into Oracle via ODBC could be done with a VBA based program, for automation, but then you would need a "always" running client computer.

Looking forward to hearing more on this subject... Regards,
/fad

"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!
>
Received on Sun Oct 29 2000 - 15:52:40 CST