Jovica Kuresevic Jovica Kuresevic - 1 year ago 65
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.