Query access database from SQL management studio without using linked servers
- by cfdev9
How do I query a MS Access database directly from SQL Management Studio, without using a linked server?
Ie. something like
SELECT * FROM ["C:\Data\Accessdb.mdb"].[SomeTableInAccessDB]
Obviously this won't work but is there a away to specify the access database details within a sql query?