Iremos conhecer as técnicas:
?Download do Driver Microsoft Access Database Engine;
https://www.microsoft.com/en-us/download/details.aspx?id=13255
?Propriedades do recurso Servidor Vinculado (SERVER OBJECTS, LINKED SERVER, PROVIDER, DATA SOURCE, SECURITY);
?Habilitar consultas no Banco de Dados Access (AD HOC DISTRIBUTED QUERIES, ALLOW IN PROCESS, DYNAMIC PARAMETERS, SQL SERVER LIKE);
?Consultar tabela do Banco de Dados Access (SELECT, OPENROWSET, PROVIDER, LOCATION);
?Criar Servidor Vinculado (ADD LINKED SERVER, ADD LIINKED SERVER LOGIN);
?Consultar tabela do banco de dados Access (SELECT, OPENQUERY, LINKED SERVER).