I have an Access Database and an Excel spreadsheet with a few hundred lines of data to update into the DB.Some of the fields in the Access database are not in the Excel spreadsheet.Is it best to write an Excel VBA script to update the Access DB or is there a better approach?I am not very familiar with Access and my VBA skills are rusty so any examples are appreciated.Some sample data, this is from the Excel:MNFile Identifier587034901 PN0003523248029409PN0003523066978806PN000456574565507 PN000477MN would be the "unique key" in Access (I'm used to SQL).These will be updates and not inserts.Thanks.
Thanks, I now have the data in another table in Access, I suppose that's half the battle!So, now I just write an update query using Access, if this was SQL I could do that in a few seconds, now I need to find out how similar to SQL Access is.
If you know SQL, you can create a query in Access, switch to SQL View and just write your UPDATE. However I would suggest you try the graphical interface (Design View). It's very easy and you will avoid the specific syntaxAccess SQL may have here and there..