...

View Full Version : 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? :confused:

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



What is the equivalent of Access table in SQL?


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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum