Hi All,
Is there anyway you can create a report in Microsoft Access as an Excel spreadsheet ? What im looking to do is pull data from an Access database and create a report in Microsoft Excel with that data.
I am unsure if the report could be created in Access and exported as an Excel spreadsheet, or if the report could be created in Excel using the Access database. THe report will have to created every week by multiple users as the database is always changing.
Im not too sure whats the best approach or if this is feasible at all. Any help anyone could provide me would be greatly appreciated.
