SQL Server Video
26 page views
2343 video views
2024, May 08, Wednesday

#108 How to Connect Access Database in SQL Server

Como consultar diretamente o banco de dados Access e disponibilizar os dados no SQL Server utilizando o recurso Servidor Vinculado

We will know the techniques:
🔹Download the Microsoft Access Database Engine Driver;
https://www.microsoft.com/en-us/download/details.aspx?id=13255
🔹Linked Server Properties (SERVER OBJECTS, LINKED SERVER, PROVIDER, DATA SOURCE, SECURITY);
🔹Enable queries in the Access Database (AD HOC DISTRIBUTED QUERIES, ALLOW IN PROCESS, DYNAMIC PARAMETERS, SQL SERVER LIKE);
🔹Query Access Database table (SELECT, OPENROWSET, PROVIDER, LOCATION); Create Linked Server (ADD LINKED SERVER, ADD LIINKED SERVER LOGIN);

🔹🔹Query Access database table (SELECT, OPENQUERY, LINKED SERVER).