Cannot insert sheets into the destination workbook

Giganews Newsgroups
Subject: Cannot insert sheets into the destination workbook
Posted by:  Anthony
Date: Thu, 12 Mar 2009


We are having a problem with Excel which I could do with a solution if

The situation is this we write a bespoke application which sits on an IBM
Universe database which we access using a program called SBClient, one of the
feature of this is we are able to run queries against the database and have
the output export in to Excel.

The problem we are having at the moment is when we try to run this query we
get a message in Excel saying:

"The file you are trying to open 'SBCLIENT.XLS' is in a different format
than specified by the file extension. Verify that the file is not corrupted
and is from a trusted source before opening the file. Do you want to open the
file now?"

We say yes to this and the information starts importing into the spreadsheet
but then we get another message saying:

"Excel cannot insert the sheets into the destination workbook, because it
contains fewer rows and columns than the source workbook. To move or copy the
data to the destination workbook, you can select the data, and then use the
Copy and Paste commands to insert it into the sheets of another workbook."

When we click OK on this message the import stops.

We are not importing much data there are only around 6 columns and not very
many rows either.

Can anyone help?