Consolidation DB

[dimitrz]

Hi experts

Introduction

My team uses an Input tracker to track Helpdesk requests and Reception calls, everyone has their own tracker which gets updates every minute of so with new entries

All these input trackers are located in a common folder in common file server

On an average every person tracks close to 100 requests/calls in his tracker everyday

Requirement

Is it possible to capture data from all these trackers on a periodic basis (say at click of a button) so that it can be displayed in a consolidated format in MS Access ?

That way I can get a consolidated overview of all the requests and calls handled by all my technicians without having to go into each person’s tracker separately

I am afraid I am a total novice in MS access and have no clue on how to go about it

I have enclosed 2 samples 1) sample of the input tracker used by technicians 2) an sample example of how I need the data consolidated in MS Access

Any help would be much appreciated

Query cross posted at
http://www.accessforums.net/database-design/consolidation-db-4936.html#post17359

[dimitrz]

Sample of Consolidation DB

Ps: Using Access 2007

[dimitrz]

Hi I have managed to create the basic structure of the DB in Access

( no coding involved - its just the structure)

Now I assistance in knowing how can I link the various excel input tracker to this DB so that every time I click a button on DB - all the data from excels are captured and consolidated/displayed in the DB

Sample of input tracker is above

[dimitrz]

I have uploaded my requirement as a slide show - hope this helps in addition to the above structure in Access


Have cross posted at http://www.access-programmers.co.uk/ aswell however I wont have the link until the mods there approves the posting

[OBP]

If you convert the database to Access 2003 I can help you, I do not have Access 2007, I also do not have Excel 2007 to look at the data.

[dimitrz]

If you convert the database to Access 2003 I can help you, I do not have Access 2007, I also do not have Excel 2007 to look at the data.

Thankyou OBP

if you can do that in acess 2003 I have no issues, 203 or 2007 doesnt matter much to me


let me know if you want any changes from my end

[OBP]

Can you post a Zipped copy of the database in Access 2003 format and a copy of a couple of the Excel workbooks/sheets?