Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4

    Unanswered: linking Acces tables from within SQL Server

    Hi,

    It's easy to use tables that reside in SQL Server tables or another database, like if they were present in Access, by defining them as "linked tables" in Access.

    Is the opposite also possible?

    I need to read (SELECT scripts), not alter (no INSERTs, UPDATEs or DELETEs), Access tables from a commercial product. Is it possible to query those Access tables from within SQL Server? Are joins between Access and SQL Server tables possible?
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Yes, you can create a MS-SQL Linked server to any ODBC or OLEDB data source. See sp_addlinkedserver or equivalent GUI tools.

    -PatP

  3. #3
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Pat,

    Thank you for your reply.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •