D
Don Johnson
I am exporting a query from Access 2007 to Excel 2007. This is done daily to
the same spreadsheet so old data exists in the spreadsheet when the export
begins. Everything seems to run as expected. From the Export - Excel
Spreadsheet window when I click OK with the existing spreadhseet listed in
the File Name, I get a Microsoft Office Access window saying, “The object
‘New’ already exists. Do you want to replace the existing object with the one
you are exporting? If you want to export this object without replacing the
existing object, click No. You can then choose a new name in the Export
dialog box.â€
I click "Yes" and get a new Export - Excel Spreadsheet window to Save
Export Steps saying "Successfully reported 'New'.", which is the name of the
query being exported and the name of the spreadsheet into which the query is
being exported.
However, when I open the Excel spreadsheet, the data that was there
previously is still there. The new data is not in the spreadsheet.
If I then delete the data from the spreadsheet so that the spreadsheet
exists but contains nothing and save this empty workbook and spreadsheet. If
I then repeat the exporting steps from Access 2007 to Excel, I get the same
messages and screens, but now the new data is there.
All of this I have documented with screenshots, however, I cannot attached
files to this forum.
To make matters worse, this does not always occur and I cannot figure out
why. Sometimes it replaces the data as designed. Sometimes it leaves the old
data in the workbook on the New spreadsheet and creates a new spreadsheet
called "New1" containing the new data.
Has anyone else had similar problems?
Can anyone suggest what else I should be looking at to fix this problem?
the same spreadsheet so old data exists in the spreadsheet when the export
begins. Everything seems to run as expected. From the Export - Excel
Spreadsheet window when I click OK with the existing spreadhseet listed in
the File Name, I get a Microsoft Office Access window saying, “The object
‘New’ already exists. Do you want to replace the existing object with the one
you are exporting? If you want to export this object without replacing the
existing object, click No. You can then choose a new name in the Export
dialog box.â€
I click "Yes" and get a new Export - Excel Spreadsheet window to Save
Export Steps saying "Successfully reported 'New'.", which is the name of the
query being exported and the name of the spreadsheet into which the query is
being exported.
However, when I open the Excel spreadsheet, the data that was there
previously is still there. The new data is not in the spreadsheet.
If I then delete the data from the spreadsheet so that the spreadsheet
exists but contains nothing and save this empty workbook and spreadsheet. If
I then repeat the exporting steps from Access 2007 to Excel, I get the same
messages and screens, but now the new data is there.
All of this I have documented with screenshots, however, I cannot attached
files to this forum.
To make matters worse, this does not always occur and I cannot figure out
why. Sometimes it replaces the data as designed. Sometimes it leaves the old
data in the workbook on the New spreadsheet and creates a new spreadsheet
called "New1" containing the new data.
Has anyone else had similar problems?
Can anyone suggest what else I should be looking at to fix this problem?