Accessing MS ACCESS through SQL

[Netfundu]

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? :confused:

What is the equivalent of Access table in SQL?

Thanks in advance :)

[Noodles24]

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