Can you use VBA to query an Access database without importing data
Hello,
I've developed an Access database that tracks service requests and when they
are opened, closed, or if and when they are canceled. I would like to
summarize this in an Excel chart such as number of requests opened and closed
by month, but would rather not import the entire data table to perform this
calculation.
Is it possible to query the data table as it resides in Access so all I have
to pull over is a few summary numbers?
TIA
Jon
|