By Using the above Code... we can access the Contents Of the table 'tblContacts' from AddressBook.mdb (MS-Access File) Present in C Drive...
U can try this Code...
First Create a ms access File in c drive and name it as AddressBook and create a table 'tblContacts' with columns ID,Firstname,Surname.. and provide some sample data...
By using the above code u can view the contents of tblContacts in SqlServer....
Read these:
OPENDATASOURCe[
^]
Ad Hoc Quieries[
^]