Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • Last Modified:

Import Workbook (Many Sheets)

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!

Thanks.
0
dougp23
Asked:
dougp23
1 Solution
 
dougp23Author Commented:
Yup, that's the ticket (with a little modifying)!

Thanks.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now