Hello,

(I can email a copy of the Table and the Spreadsheet I am referring to in this post.)

I have a table that I would like to update with certain fields from a spreadsheet. The table represents all of the property records for the county I live in. The table has a unique data field for every record called a "PIN" (Property Indentifier Number). It is in this format: 12-3456-78-90. Because the PIN's were hand entered, sometimes there is a space between the dashes and the numbers, but each PIN is different for every record.

The data from the spreadsheet I want to import has updated sale information for the property records in my table. I want to associate the PIN's in the spreadsheet to the PIN's in my table and only import the new owners name, sale date, and sale price from the spreadsheet to the table.

How would I do this import? It is probably straight forward, but I am a newbie with Access.

I am concerned that because the PIN from the Speadsheet was typed differently from the one table, the import won't work. The numbers are the same, there are just spaces between some of the numbers and dashes. I tried to do a "find and replace" in excel, but it will not find a blank to replace with a dash.

Thanks

What if in Excel you do a find on "- " (dash w/space) and replace it with "-" (dash w/out space)?

You do have to have the PIN's match in order to link to the sheet and do any type of automatic updating.

Hope this helps!

You need to conform the PIN # to a specific pattern. You should be able to search and replace on a space. Just hit the space bar and then put a dash in the Replace. I just tested it and it worked. You can then remove extra spaces by searching for a space and replacing with nothing.

Once you do that you can link to (or import) the spreadsheet, then do a join between your table and the spreadsheet. Convert the query to an Update quesry and it will only update matching PINs.