Locate a single row in excel

[Steve]

I'm trying to update a single customer in Access with information stored in
an xls spreadsheet. If column A, for example, contains the Customer Id's, how
would I look for the row in xls that matched my customer_Id in Access?

 

[Pete D.]

I would go the other way and import the spreadsheet into access complete to
a new table and then do an update query. Link the two tables customer id
together and query is done.

 

[Klatuu]

Use the transferSpreadsheet method to links the spreadsheet as a table. Open
the table as a DAO recordset. Use the FindFirst method to locate the
customer.