hi,
I have MS Access Database (test.mdb), and i have a table called tblEmployee in that.
How to query the table from SQL Server Query Analyser?
Thanks in advance
qAnandYou would have to create a linked server to the access database and reference the table with OPENQUERY in your SQl statement.
See "Configuring Linked Servers" and "OPENQUERY" in Books Online for direction on this.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment