copying recordset to Access table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am new to access programming. I have got data from an Oracle source into a
recordset in an Access form using database.createQueryDef(). I need to move
this into a table I have in the same database. Can I use
doCmd.TransferDatabase to do this movement? Can anybody please help me with
the syntax?
Thanks,
Supriya
 
Hi Supriya

Personally, I would go to the tables screen, and create a linked table (or
tables) to the relevant Oracle table(s).

You will then be able to use the data in these Oracle tables in any queries
in Access.

You may find that once they're linked you don't need to copy any of the data
into an Access table as you'll be able to use it directly in Oracle via the
linked table.

If you do need to store the data in Access itself (maybe because the Oracle
value will change and you need to record what it "used to be") then just use
a standard update or append query to do this.

Post back if you need more info

Kind regards

Andy Hull
 
Back
Top