updating information from excel to a access table

[Guest]

i have a table in Access that has the following headings: ID number
(Autonumber), First name, Last name, Invoice number, Etc...

Now we've changed our invoice number systems so the invoice numbers in
Access are invalid and I've put the correct new invoice numbers in my excel
spreadsheet.

How do I know update my Access table with these new Invoice numbers in my
excel spreadsheet. Is there a way I can do this? I have over 2000 of them.

Thanks in advance for your help

 

[Guest]

yes, you can do it with an update query, make a spreadsheet with two colums,
oldnumber and newnumber, then import it into a new table, etc.