Hi all - hope you can help
Using the code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "tblTrade", "C:\internal.xls", True
I wish to export all data from tblTrade in Access 97 to Excel 2000, but I am geting the following error:
Table 'tblTrade' already exists. (Error 3010)...