S
Sho
I have an access database that holds details on computer equipment
I also have an Excel spreadsheet that contains this data but holds full
records for all employees. I am looking for a way to bring this data into
Access but only bringing in those records that are missing and entering them
into the correct areas e.g.
Access Database Table
Tag Serial No Equipment Assigned to
1001 123456 Laptop J Bloggs
1005 PC S Smith
1007 789101 PC
Excel Spreadsheet
Tag Serial No Equipment Assigned to
1001 123456 Laptop J Bloggs
1005 456789 PC S Smith
1007 789101 PC W Williams
When I import the excel spreadsheet to the database table I would want it to
fill in the spaces for 456789 and W Williams.
Is this possible?
I also have an Excel spreadsheet that contains this data but holds full
records for all employees. I am looking for a way to bring this data into
Access but only bringing in those records that are missing and entering them
into the correct areas e.g.
Access Database Table
Tag Serial No Equipment Assigned to
1001 123456 Laptop J Bloggs
1005 PC S Smith
1007 789101 PC
Excel Spreadsheet
Tag Serial No Equipment Assigned to
1001 123456 Laptop J Bloggs
1005 456789 PC S Smith
1007 789101 PC W Williams
When I import the excel spreadsheet to the database table I would want it to
fill in the spaces for 456789 and W Williams.
Is this possible?