We recently upgraded office from 2010 to Office 365 and now after years of proper service, after upgrading from version to version, all of sudden my export from Access to Excel is failing.
I have a number of exports to the same workbook creating worksheets.
The workbook contains some other sheets that create graphs based off the information sourced from the exported sheets.
Oddly enough, I seem to be able to "fix it" by renaming the offending sheets and having them (recreated) from my export code (just simple DoCmd.transferspreadsheet) and then fixing the inter workbook relations (back) to the old name, but new sheets.
A part of the problem seems to be that when exporting the sheet, the data is removed from the existing one for the amount of data that you are trying to add. Which in this case is LESS than what was there. The "surplus" data that was there, remains and might be causing the problem....
Once the issue has been circumvented by one of the two above solutions, I seem to no longer encounter the issue. :banghead:
Google returns hits from different fora (Mr Excel, Utteraccess and more ...) and different versions like 2003 and 2007. Most common solution seems to be "delete the file first, then export it"
Which I cannot do, due to the graphs and reports running inside the workbook...
fixing it like per above seems to have eleviated the issue for me (for now).
What kind of stupid issue is this?? Really this shouldnt be happening, totaly discrediting my databases and reports all over the place !!! :banghead:
I have a number of exports to the same workbook creating worksheets.
The workbook contains some other sheets that create graphs based off the information sourced from the exported sheets.
Oddly enough, I seem to be able to "fix it" by renaming the offending sheets and having them (recreated) from my export code (just simple DoCmd.transferspreadsheet) and then fixing the inter workbook relations (back) to the old name, but new sheets.
A part of the problem seems to be that when exporting the sheet, the data is removed from the existing one for the amount of data that you are trying to add. Which in this case is LESS than what was there. The "surplus" data that was there, remains and might be causing the problem....
Once the issue has been circumvented by one of the two above solutions, I seem to no longer encounter the issue. :banghead:
Google returns hits from different fora (Mr Excel, Utteraccess and more ...) and different versions like 2003 and 2007. Most common solution seems to be "delete the file first, then export it"
Which I cannot do, due to the graphs and reports running inside the workbook...
fixing it like per above seems to have eleviated the issue for me (for now).
What kind of stupid issue is this?? Really this shouldnt be happening, totaly discrediting my databases and reports all over the place !!! :banghead: