View Single Post
  #2 (permalink)  
Old September 1st, 2006, 07:54 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I would import the entire spreadsheet in to a second table.
Then you can code the Update.
Either create an update query if that will do it, or write code to open a recordset on each table, and parse through the records one at a time.

So it seems what you want to do is take data from Excel, and then where the PartNumber matches the PartNumber in the table, to overwrite Manufaturer and ConfigDate?


mmcdonal
Reply With Quote