can I include an access table in a SQL 2000 query?

[Leathergator]

I have an sql query that needs to link to a table in Access. I have not been able to find a syntax that allows this. Say that I have Employee table in SQL 2000 and Address table in Access. Something along the line of:

Select EmployeeName, PhoneNumber
From Employee -- this is a SQL table
Inner Join Address -- this is an access table
on employee.employeeID = Address.EmployeeID

I know I can do this in reverse from access and link to SQL but can I do this in SQL linking to an Access table?

 

[bborissov]

Why?
1. Check OPENQUERY() in BOL.
2. You could add a linked server to your Access DB and use it.



Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.