Importing data to MS Access from MS Excel
Posted on 2014-04-20
I have 1000 rows or "records" of applications in my excel spreadsheet. But they only represent 100 unique devices that are already represented in my MS Access database. I have successfully linked my excel spreadsheet, I have even been able to move it to a table, but this is not enough.
I want to get the data into it's respective tables and associated with the respective machines. I'm stuck at this point. MS Office 2010.