Populate Access table with Oracle data - how?
From: dj (dj_at_discussions.microsoft.com)
Date: 11/23/04
- Next message: john smith: "ADO reconnect after disconnect"
- Previous message: Tommy: "vbajet32.dll failed to initialize reinstall the application"
- Next in thread: Panayotis Papapostolou: "Re: Populate Access table with Oracle data - how?"
- Reply: Panayotis Papapostolou: "Re: Populate Access table with Oracle data - how?"
- Reply: mautobot: "RE: Populate Access table with Oracle data - how?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Nov 2004 06:29:08 -0800
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: john smith: "ADO reconnect after disconnect"
- Previous message: Tommy: "vbajet32.dll failed to initialize reinstall the application"
- Next in thread: Panayotis Papapostolou: "Re: Populate Access table with Oracle data - how?"
- Reply: Panayotis Papapostolou: "Re: Populate Access table with Oracle data - how?"
- Reply: mautobot: "RE: Populate Access table with Oracle data - how?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
