Locate a single row in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 21 May 2008 19:39 GMT

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?

Reply to this Message

Pete D. - 21 May 2008 23:57 GMT

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.

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

Reply to this Message

Klatuu - 23 May 2008 14:46 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

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

Reply to this Message