How import linked table to Access ?

[David]

I have 2 access systems. One has a single table linked to
a SQL Server database table. I want to combine this table
with the other system which is solely Access based.

I need to import the Access table based on SQL Server,
into my other Access system. But when I do that it just
gives me a link back to the SQL Server table. I need to
import the table as an Access table. How do I do that?

Both systems are front-end/back-end and Access 2000.

 

[Matthew Mark]

I'm not sure I have enough to answer the question. But, if
you really want to import, just import it. If you link,
then you get the link to sql server. The other solution is
to create a make table query in the database linked to sql
server, that makes a table in the second database. When
you choose, make table, it asks if it's in the same or
another database. However, if you want live data, you'll
have to go with database2 pointing to database1 which is
pointing to sql server.

 

[David]

No, when I specify import it sets up the link, even when I
say to ignore the data and just do the specifications.

 

[Jeff Boyce]

David

Define "combine". Is there a reason you can't use a query to link/relate
the two tables and return only those fields you wish to display?

Good luck

Jeff Boyce
<Access MVP>