Check if data in a closed workbook is present in Access table

[aman]

Hi All
I am using the following line of excel vba code to extract the name of excel file that I would like to compare with Access table data.

strFile = Application.GetOpenFilename("Excel Files,*.xls*")
textbox1=strfile

Now i want to write VBA code to check sheet name "Summary" in that workbook and check if any of column D value matches with Access table tblmain field "Reference" values. If yes then change the status field of tblmain to "Yes".

Any help would be much appreciated.
Thanks

 

[Mihail]

Take a look here, maybe will help yo.
http://bytes.com/topic/access/answers/932581-discussion-fully-customized-export-data-access-excel