Accessing MS ACCESS through SQL

Netfundu · 02-10-2005, 09:38 AM

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

Noodles24 · 03-28-2005, 11:13 AM

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

Quote:

What is the equivalent of Access table in SQL?

They're just called tables, same as every other database