too many fields - hair tearing out at this point

  • Thread starter Thread starter ktdid
  • Start date Start date
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.
 
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.
 
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.
 
Back
Top