too many fields - hair tearing out at this point

K

ktdid

Hi - I am exporting a crosstab query to Excel. When it exports to an
existing spreadsheet named Schedule I get the too may fields error. If I
export to a new spreadsheet, it works fine. I would really like to keep
overwriting the existing spreadsheet. Why is it doing this and how can I fix
it? 6 fields in original table, 116 records. Oy.
 
J

John W. Vinson

Hi - I am exporting a crosstab query to Excel. When it exports to an
existing spreadsheet named Schedule I get the too may fields error. If I
export to a new spreadsheet, it works fine. I would really like to keep
overwriting the existing spreadsheet. Why is it doing this and how can I fix
it? 6 fields in original table, 116 records. Oy.
Click to expand...

Please post the SQL and post your code.
 
B

Bob Quintal

Hi - I am exporting a crosstab query to Excel. When it exports to
an existing spreadsheet named Schedule I get the too may fields
error. If I export to a new spreadsheet, it works fine. I would
really like to keep overwriting the existing spreadsheet. Why is
it doing this and how can I fix it? 6 fields in original table,
116 records. Oy.
Click to expand...

Check that the existing workbook does not have any cells set to
protected.
 

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 crosstab query too many fields error 1
Too many fields detailed 2
Too many fields defined 1
"Too many fields defined" Error 6
too many fields in a table 6
IF function says too many nested 1
export crosstab query too many fields defined 3
"too many fields defined" error 24

Top