Copy tables and query

[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!

 

[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!

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!