While trying to output a report as an Excel file, we've been receiving the following error message while connecting to one database in particular lately.
An error occurred during a cOPY TO command while processing query results. Foxfire! cannot complete the requested action.
We are using Excel 2003 on Windows XP machines.
We've been using this feature to connect and create reports from other databases with no problems.
I am able to see a count of records returned by the query without errors, and I've verified the query is fine.
Any assistance in figuring this out will be greatly appreciated.
Dale Millson
DBA