Excel Spreadsheet Object - Maximum Amount of Data

G

Geoff

I am using an excel spreadsheet object on a web page to display the
results of a SQL query to my users. The query is returning
approximately 2000 rows with 9 columns in each row.

The issue I am running in to is that the data is getting cut off in the
excel object.

I have verified the recordset itself is being returned with all of the
data.

I am wondering if anyone knows if there are any limitations on the
amount of data these objects can hold? Is there a setting I can use to
increase the limit, if there is one?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking data in MS Word into Excel 5
Problems starting Word from Excel VBA 3
How DO I Increase The Excel Cell Comment Data Capacity? 1
SQL not importing records from ACCDB 2
Addressing HTMLText object in Spreadsheet VBA Script 3
Excel wrapping incorrectly 1
Missing default cell styles on some large existing spreadsheets 0
merging spreadsheet data 1

Top