1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br
Cookies Anuncie aqui Patrocinador Anuncios

Querying Access from SQL Server

Discussão em 'Outras Linguagens' iniciado por Stack, Janeiro 21, 2021.

  1. Stack

    Stack Membro Participativo

    I have a large query that is built in SQL server and I need to query a table that is in an Access database. Is there any way to do this without using OPENROWSET() which is disabled by my DBA? I can't figure out the import wizard and copy pasting the actual rows into a temporary table won't work bc it's over 50k rows.

    I have a bad feeling the only solution is creating a linked table to SQL server from Access and rewriting my query.

    Continue reading...
    Stack, Janeiro 21, 2021
    #1

Compartilhe esta Página