Post reply

Link Access database to SQL server

  • August 2, 2016 at 1:59 pm

    #310209

    I knew how to link SQL server tables to Access via ODBC.

    How to link Access database to SQL server so that I can view Access tables in SQL studio window?

  • August 2, 2016 at 3:55 pm

    #1893369

    adonetok (8/2/2016)

    I knew how to link SQL server tables to Access via ODBC.

    How to link Access database to SQL server so that I can view Access tables in SQL studio window?

    Use a linked server.

  • August 3, 2016 at 5:51 am

    #1893445

    ODBC table links are created via linked table manager, google will detail exactly how to connect

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply