Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Jun 2004
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Accessing MS ACCESS through SQL

    Hi,

    Just need some help..I have installed SQL 7.0 at my work PC and I do have MS Access installed. Is there a way where I can use the Table from MS Access and run Query using SQL server?

    What is the equivalent of Access table in SQL?

    Thanks in advance

  • #2
    Regular Coder
    Join Date
    Feb 2005
    Location
    UK
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You'd have to import the data into SQL server in order to run queries on that data. You can then link tables in access to the tables in SQL server, they should act as if they are local to the access database

    What is the equivalent of Access table in SQL?
    They're just called tables, same as every other database


  •  

    Posting Permissions

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