I'm hoping you might be able to help me. I have a simple access query. I was using the following command *******:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "1099 Export", "test ramquest export.xls", yes
problem is that it give me an error about the version that the excel file is in. It wasnt doing that before, but now it is.
Other problem is that it doesnt seem to over write the data.
If I choose 02/01/04 as the start date parameter, and 08/01/04 as the end, I get that data. But when I make the end date 05/01/04 or something, it still shows for dates through to 08/01/04.
What can I do to have it overwrite the data?
Any help is appreciated....