Re: Getting data via ODBC

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 - 14:15:30 CST