Copy tables and query

G

Golfinray

Can I copy or import some tables (3 or 4) and one query from one database
into another so I can use them to create a form in the other db? Both are
2003 with sp3. Or, would it be better to link, or use some other method. Or
could I just call the path to the other db? Thanks so much!
 
J

John W. Vinson

Can I copy or import some tables (3 or 4) and one query from one database
into another so I can use them to create a form in the other db? Both are
2003 with sp3. Or, would it be better to link, or use some other method. Or
could I just call the path to the other db? Thanks so much!
Click to expand...

The queries can and should be imported - File... Get External Data... Import
on the menu. Tables should be linked, not imported, unless you have good
reason to store the same data in two different databases, and allow the
records to be chnaged in each database so that the two databases won't match!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

update query vs make query 5
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Accessing Database design mode 5
tinkering with split databases 0
Testing DB and ..... 4
Is it possible to / and how do I / copy only some tables from a db 6
Transfer Joined Tables Through A Select Query 1
Access Passing the value to a table 1

Top