Need some pointers on creating a simple inventory database
February 22, 2012 7:02 AM Subscribe
Need help setting up a simple Access database. I'm trying to reconcile a bunch of inventory, which is all recorded in multiple Excel spreadsheets. I want to import all the Excel files into an Access database so I can match them up all at the same time.
posted by smoothvirus to computers & internet (8 answers total) 4 users marked this as a favorite
What I have is a master spreadsheet with the inventory for our organization. This master spreadsheet is updated every week and has about 50,000 lines.
I also have about a hundred other spreadsheets with items that were removed from our facility. I need to compare all these other spreadsheets against the master inventory to check that none of the removed items are still on it.
I know how to use the MATCH function in Excel to compare the spreadsheets one at a time but that's time consuming when I have around 100 files.
I do know how to import all the spreadsheets into Access as tables, but I'm lost on how to link the tables or run queries from there so I can get a report showing which property items need to be taken out of inventory.