Re: Populate Access table with Oracle data - how?
From: Panayotis Papapostolou (pappyATmagnetDOTgr)
Date: 11/23/04
- Next message: Cindy Winegarden: "Re: Connecting to a FoxPro DBF file"
- Previous message: john smith: "ADO reconnect after disconnect"
- In reply to: dj: "Populate Access table with Oracle data - how?"
- Next in thread: mautobot: "RE: Populate Access table with Oracle data - how?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Nov 2004 17:50:29 +0200
I cannot imagine of a better (or different) way to do this. The reason is
that Oracle data definitely have to pass through your computer to get into
the local access table.
"dj" <dj@discussions.microsoft.com> wrote in message
news:BA3680A3-ADAD-4A63-836C-DEF2C635CC37@microsoft.com...
> It seems simple enough. I need to get one or more rows, based on a WHERE
> clause (parameter), from a single linked Oracle table via ADO and put the
> results in a local Access 2000 table for later use. This takes place in
> the
> same Access 2000 db.
>
> Getting the data is not problem, but it seems like I should be able to do
> the whole thing in a single INSERT statement: INSERT INTO [Access table
> columns] SELECT [Oracle columns] WHERE [Oracle column] = [parameter
> value].
>
> But I get an error (ORA-00942) from Oracle because Oracle doesn't
> recognize
> the local Access table. I could open an ADO recordset and loop through
> that, putting the rows in the local table, but that seems inefficient.
>
> Anyone have a better way?
>
> TIA,
> dj
>
- Next message: Cindy Winegarden: "Re: Connecting to a FoxPro DBF file"
- Previous message: john smith: "ADO reconnect after disconnect"
- In reply to: dj: "Populate Access table with Oracle data - how?"
- Next in thread: mautobot: "RE: Populate Access table with Oracle data - how?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
