Locate a single row in excel

S

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?
 
P

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.
 
K

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.
 
Top