Export to Excel not replacing spreadsheet

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 :(
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prompt for file location Export to Excel 4
Add Date to export file Name 1
Excel export problem 2
Syntax to combine transfer spreadsheet & Openfilesave API 8
Export to Pocket Excel 1
export to excel 1
Transfer Spreadsheet Current Record 0
export two sheets in same excel file 1

Top