import or query another db to get weekly data for a report

[Guest]

I realize I might not need an import because I don't want to write over the
imported data each week. Do I use a SQL update or append query to get data
from an Access db on our network? I don't see the tables in my query design
tool so I'm wondering how I do the query if I can't see the tables for the
other database.

thanks,

 

[Guest]

Are you trying to append data from an Access database to a SQL server table?
Or are you trying to append data from a table in one Access db to a table in
another Access db?