From the "I-hate-Microsoft Office-But-It's-All-I-Have" Department:

Here' at work my department tracks monthly numbers for our department and this is usually falls into the category of an Excel chart that we track the different items and it totals these things up. Now I was thinking, it would be better if we would be able to port these totals over to Access (again, what I have access to and have permission to use for work) to create reports etc. How can I link my front end in Excel to a backend in Access without trying to do a manual import of Excel data while in Access?

As of now we are using Office 97 but they tell me any day that e are supposed to be upgraded to Office 2000. That could and should be this weekend or it might (and probably will be) several weeks or even months down the road.

Any ideas?

Sketch