Export to Excel not replacing spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using following method to export a table to Excel:
DoCmd.TransferSpreadsheet acExport, , "tblReport", "C:\CAIMPKC\CA_Imports.xls"

But it is not replacing the existing file, it just adds to it causing the
file to double/tripple, in size. It is also not formatting it, i looks like
a csv export instead of an Excel formatted one.

Please help :(
 
Back
Top