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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janis - 31 Jul 2007 23:04 GMT

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,

Reply to this Message

mray29 - 31 Jul 2007 23:34 GMT

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?

> 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
[quoted text clipped - 3 lines]
>
> thanks,

Reply to this Message