export to Excel - too many fields defined

D

Daniel

Hi,

I'm using Access 2000.

When I try to export a query to Excel using the TransferSpreadsheet
action, I get a "Too many fields defined" error. There are 45 fields
visible and several invisible fields in the query. If I have a
slightly smaller number of fields (for example, 41 visible fields),
then it works fine. I have tried a compact-and-repair, but it did not
help.

This is the command I use:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
"Current Filter", TEMPLATEFILEPATH

Is there a hard-limit to the number of fields which can be exported to
Excel, or am I missing something?

Thanks,
Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export BPMN Visio Chart to Excel 0
export crosstab query too many fields error 1
Too Many Fields Defined Error 1
"Too many fields defined" Error 6
export crosstab query too many fields defined 3
Too many fields 3
Export Report with Graph to Excel error 2495 1
Error 3190 - "Too Many Fields" - Need this Export to Happen 0

Top