Locate a single row in excel

  • Thread starter Thread starter Steve
  • Start date Start date
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?
 
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.
 
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.
 
Back
Top