error exporting spreadsheet

[Andy]

I am using the Transferspreadsheet Action to transfer the
results of a select query to an exisiting workbook in
excel 10. This should just insert a new sheet into the
exisiting workbook with the new data.
However, when I run the action, it gives me an error
message,
"Cannot delete spreadsheet cells."

This is weird because I am not deleting any cells, only
adding a new sheet.
Why is this happening?

 

[Ken Snell]

Any chance that the query you're outputting has more than 65,536 records?

Post the macro's actions and arguments.

 

[Andy]

No, the query has less than 65,536 records...
I think this error might have something to do with the
clipboard...
In the macro, I run two Transfertext arguments to
import .csv files into access. Then I have five runcode
arguments where I run update queries that were too long
for the runsql arugment. Then I have a runsql argument
for a shorter update query.
Finally, I have the transferspreadsheet argument to move
the result of a query on the imported data into access.

Let me know if you need anymore info....

 

[Ken Snell]

I've not seen this error before in a TransferSpreadsheet action. I cannot
imagine why the clipboard would have any bearing on it.

Post the SQL of the query that you're trying to export.

 

[scott]

The only thing I put in the macro is(I odnt know how to
program in Access)

I use OPEN QUERY
Then I use SEND QUERY and I send it as an excel file. It
runs for about 5 minutes then I get the error.

Scott

 

[Ken Snell]

The only other idea that I've gotten from another MVP is that the
spreadsheet cells may be locked and therefore ACCESS cannot write into them.
Any chance that that is your situation?

Also, post the SQL statement of the query that you're exporting. Are you
using OpenQuery for the same query that you wish to export? If yes, delete
that OpenQuery step; it's totally unnecessary, and you are then trying to
export a query that is already opened. I don't know if that will create the
problem that you're seeing, but it is not a good thing to have!

 

[Ken Snell]

You're welcome.

AMAZING!!!!!! I removed the open query and just included
the send query and it exported everything PERFECTLY with
all the rows!

Thank you so much.

Originally it was giving me an error saying too many rows.

Scott