question

jdbouch3144 avatar image
jdbouch3144 asked

Hresult: 0x80004005 Description: "Spreadsheet is full.".

When trying to create a 2003 excel spreadsheet, I received "spreadsheet is full" error. I changed my Engine to ACE and Excel version to 2007 and extension to XLSX. My Drop Table SQL task doesn't work as before and the Create Table Table SQL Task. Actually, it appears that the drop table works however, the create table says the table already exists. What's going on? The file path is accessible to the SQL server.

Thanks

ssis excel
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

How much data are you trying to put into the spreadsheet? Excel 2003 has a maximum of 65536 rows / 256 columns per sheet...

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.