Hi Tony,

Thanks for the prompt response. First thing is i am new to VBA . When i execute the query doing F8, the Select statement gets executed. the next line where i open the recordset i get an error there. I checked the format of cells in access and excel and it is the same. date format for date and text format for location.

Sujit