Export query data from MS Access to MS Excel

  • Thread starter Thread starter Craig Sira
  • Start date Start date
C

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
 
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
 
Back
Top