Updating data in a local database with values from a remote database

[pumkin]

Just wondering if anyone can tell me how I can perfom an update query (through SQL embedded in VBA) that will update a column in my local Access database with values from a remote Oracle database.

I have tried using a pass through query, but I don't know how to reference the local database table. I can perform this operation in the QBE by using an update query, but I need to do this in VBA. This works in VBA if I create a normal QueryDef using the same SQL that generated by the QBE however, I get a login prompt for the remote database. I really need to set the QueryDef connection property, but as soon as I do this, my query becomes a pass through query (I presume) and I can't find the syntax to reference my local table.

Thanks in advance

 

[ide]

i have a VBA proc, what:
runs a query (using ole) into a recordset, and stores the recordset in a local table. You could use the local table to create update query, or the recordset to create a procedure to update the table fields.