So I saw the post here, about exporting access to excel. The answer was perfect, however I could not comment to add a follow up question as follows.
Is it possible to append an access table to the end of an excel spreadsheet? If so how.
Asked
Active
Viewed 69 times
0
-
Have you tried `Data>>From Access` in Excel ? – Tim Williams Mar 11 '15 at 19:06
-
im looking for a way to do it out of access. i have a lot of data that i need in excel for the people consuming it, split into several workbooks, id rather not have to go into every excel book manually to update it – loegare Mar 11 '15 at 19:40
-
You can use automation to open your excel files and place the data. – Tim Williams Mar 11 '15 at 19:52
-
darn, i was hoping there would be an easy way to do it, similar to the method in the link in the original post, thanks for your help! – loegare Mar 11 '15 at 19:55
-
This link which is posted as an answer in your linked question shows how to automate Excel from Access to do what you want: http://access.mvps.org/access/modules/mdl0035.htm – Tim Williams Mar 12 '15 at 05:24