Linking Excel Cells To Access Database (1 Viewer)

[jereece]

Lets say I have an Access database called "GroupReport.mdb". That database has several queries "group1", "group2", etc. that pulls data from an external data source to show open work orders for that particular group. And lets say I have an Excel spreadsheet. In that spreadsheet I have column A listing each group and in column B I want to show open work orders from the Access queries (i.e. GroupReport.mdb/groupX).

My first problem is that the Access query will return a list of the work orders that meets the criteria. I need to simply count these.

My second probmel is that while I have imported data into Excel before, I have never linked a single cell to an Access Query.

So can someone help me figure out the best way to do this?

Thanks,
Jim

 

[HaHoBe]

Hi, Jim,

maybe use query to pull (or Access to push) your data into a spreadsheet and work from there on? Otherwise I would recommend to use a way like Copy data from an Access database into Excel with ADO.

Ciao,
Holger