Thanks guys for ur quick reply.. but i get the following error code when i tried running the query

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

i just substitued my file name and my folder name in ur query.. am i missing something here?