Import Workbook (Many Sheets)
Posted on 2011-03-08
I don't know if there's a nice clean way to do this, but I'll ask!
For years, my dept has put all vehicle maintenance into an Excel spreadsheet. Each sheet is for one vehicle, so all the maintenance entries on Vehicle 37, are on sheet 37.
Now, we are being told to convert this system to a pre-packaged Access based system. The access system has a table of "maintenance entries", where it wants a Vehicle ID, and then as many entries as you choose.
Is there a way to import all this? (Sort of like "Import all Sheets from AutoWork.xls But take the Vehicle ID from the top of each sheet, and import all the work on that sheet before you move to the next sheet")?
Does that make sense? Importing one sheet is a breeze, a little bit of editing, but nothing major. Importing more than 100 sheets is going to be painful!