1. What are the avaliable methods to open and read Excel file (i.e. csv, xls) in VB? I need to write a routine to update rows from excel (CSV format) to tables in SQL database.

2. What are the avaliable methods to do a quick search in a ADO recordset?

My routine needs to read from a file with over 10000 records, then add to a table if record not exists in SQL table else update existing record.

"Seek" method is not supported in SQL database, I have tried using Find method:
tbl_xxx.Find "IndexField = " & SearchData

But processing is very slow, take abt 1 hr. Anyone can help?