Export query data from MS Access to MS Excel

[Craig Sira]

I am using the TransferSpreadsheet macro in MS Access to
replace data in a specific sheet in an MS Excel
workbook. At first this was working very well. Then it
began to create new sheets with a "1" at the end or gave
me an error message saying the sheet already exists. If
I point the macro at a new workbook it will work fine for
awhile (replace the data in the sheet with the new data)
and then it begins to turn bad by adding a "1" at the end
of the sheet name or error out.

Thank you,
Craig Sira

 

[Larry Daugherty]

There are any number of ways you can address the problem you describe. The
simplest is to simply Kill (delete) the existing workbook and then create a
new, empty workbook from within Access and then export your data to the
clean workbook.

HTH