B
bk
I am a very novice Access user, so i'm sure this is
actually easy to do.
Basically, I have created several queries, and I just need
to export the number of records found in each query to
Excel. I would like to do it so that when a new record is
added to Access, the Excel file automatically updates
itself. I have tried going in Excel and importing the
Access query data to a worksheet, then counting the number
of records. Is there an easier, more effective way?
Please help... thanks!
actually easy to do.
Basically, I have created several queries, and I just need
to export the number of records found in each query to
Excel. I would like to do it so that when a new record is
added to Access, the Excel file automatically updates
itself. I have tried going in Excel and importing the
Access query data to a worksheet, then counting the number
of records. Is there an easier, more effective way?
Please help... thanks!