Software

Ask something
Discussion Locked

Linking db's

0 helpful
2 replies

by myriamdero

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all

I have a db in MS Access and another one in SQLServer. They have partial identical information and I need to connect them so that they have the same information.
How could I do this?

Tnx

Myriam

2 replies

by mrspost

If this were me, I would make the SQL table the source table and just link to it in Access.

by martin

Use the Data Transformation Servives in SQL Server (also known as Import Data)

This discussion is closed to new replies.