This command works well for exporting an access table to excel.
I cannot find the correct syntax to export an access table to a dbf file.
Thanks
Charllie Crimmel
Access to Xcel
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "exporthist", "c:\exporthist.xls"
Access to DBF...