Overview: Actually I am creating multiple databases in Excel and then based on triggering of a check box (or boxes) I need to do same processing in MS Access. To elaborate on this, I have given some bullet points of what I am trying to achieve.

1. Create multiple DB's through various worksheets in excel. This will actually contain some data sources like
Worksheet 1 is for Telephone [fields ... Scenario ID, HL Scenario, Scenario Detail]
Worksheet 2 is for Electoral [fields ... Scenario ID, HL Scenario, Scenario Detail]
....

2. There is a separate tab in excel which will list down these data based on some filtering rules applied (Already DONE)

3. Now in the listing sheet, I have multiple check boxes for each of the Scenario ID which will be listed. Say for eg.
Check Box 1 - Scenario ID 1
Check Box 2 - Scenario ID 2
...

4. Now, on checking the check boxes, I want to connect to MS Access DB which actually is containing my Data for that particular scenario ID. And I want to load the data for the checked scenarios to my mainframes DB through a batch job call (whose script is already prepared).

I just want to know how can I connect my excel to access and also to trigger those scenarios in Access which are checked in my excel.

All the GURU's out there please help me!!!