Jovica Kuresevic Jovica Kuresevic - 1 year ago 74
SQL Question

Joining data from Access and SQL tables

I have one access table like this

id FrstName LastName Status
1 John Smith 1
2 Mike Black 0

This is table from Project 1. I have to work on Project 2 where I have SQL table.
In this project I need to combine data from access (Project 1) and data from SQL (Project 2).

Is there a way that I join table from SQL with table from access?

Answer Source

You can link access database in SQL server over option Linked Server and then you can use that for querying.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download