Hi All
I have a table with product information consisting of half a dozen fields. We recently updated some of our remote systems and the new data was recorded on a spreadsheet. I was to import the data into my database and update some of the fields with the new info, for example:
Database table has 4 fields:
Serial Number - 98746321
Asset Tag - 00001526
Location - Our Stock
Item Description - Dell5810
Spread sheet has 3 columns:
Serial Number - 98746321
Asset Tag - 00001526
Location - 0250
As you can see, the location has changed..... and there is no item description on the spreadsheet.
If I try the usual import spreadsheet route I will get a "Duplicates" error.
How can I import the spreadsheet and have it only change the fields where the data has changed?
I'm sure this is simple to you experts but if you can help with full instructions including any code, that would be great.
There are 7500 entries to update, so will take too long to manually search each serial number in a form and make the changes there.
Many Thanks
Iann