error exporting spreadsheet

  • Thread starter Thread starter Andy
  • Start date Start date
A

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?
 
Any chance that the query you're outputting has more than 65,536 records?

Post the macro's actions and arguments.
 
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....
 
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.
 
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
 
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!
 
You're welcome.

scott said:
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
Click to expand...
 
Back
Top