GumbyD
Accessosaurus
- Local time
- Today, 20:15
- Joined
- Aug 21, 2003
- Messages
- 283
I have written some code to export a query to excel. I am using the docmd.transfertext command. When it hits the line of code that executes the export the error "Run Time Error 3190. Too many Fields defined" comes up. The query I am trying to export has only 15 columns and I have repaired and compacted the database. When I export the query to excel from the datasheet view it goes without any problem. I dug around on the web and could not find any references to this specific issue. If you know something about it I would love to know it too. It is an Access 2000 database. Here is the line of code that is producing the error:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EmployeeInfo", "C:\App.xls", -1
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EmployeeInfo", "C:\App.xls", -1