I have two access db's and need to pull a couple of table values from one db and put them into another.
I really need the data for a report.
1. Can I pull the table values to from one db to another?
2. What is the best way to do this ?
Thanks!
I have two access db's and need to pull a couple of table values from one db and put them into another.
I really need the data for a report.
1. Can I pull the table values to from one db to another?
2. What is the best way to do this ?
Thanks!
Could set a link to the other db table and use the link table just like any other table. Include it in the query for the report.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.