JMongi
Active member
- Local time
- Yesterday, 23:09
- Joined
- Jan 6, 2021
- Messages
- 802
As I usually do, as my first Access project I have an ambitious plan to create a standalone Access app for use by many in our company to manage various appropriate buckets of data (inventory, purchasing, asset management, etc). As a stepping stone in dragging our companies data kicking and screaming into the modern age, and to demonstrate some ownership of this data in advance of the full blown rollout, I would like to export the results of a few queries into an excel spreadsheet for use by the powers that be in a way they are currently used to doing.
To that end, I would create a basic Excel template file that is formatted appropriately (sheet headers, column headers, any formulas, etc). Then, I would like to export data out of an Access query and into this excel template file without affecting the existing formatting. I've searched and found quite a few links to various methodologies. I don't know any of them very well, so, before I spend a lot of time figuring them out, I thought I would focus my energies on the one(s) that can accomplish my stated goals.
There was one methodology involving copying a recordset but it wasn't clear if the copying process overrode the existing formatting in the target spreadsheet.
Thanks for your input!
To that end, I would create a basic Excel template file that is formatted appropriately (sheet headers, column headers, any formulas, etc). Then, I would like to export data out of an Access query and into this excel template file without affecting the existing formatting. I've searched and found quite a few links to various methodologies. I don't know any of them very well, so, before I spend a lot of time figuring them out, I thought I would focus my energies on the one(s) that can accomplish my stated goals.
There was one methodology involving copying a recordset but it wasn't clear if the copying process overrode the existing formatting in the target spreadsheet.
Thanks for your input!