Exporting Datagrid to Excel Question

[MikeDamone]

Hi all,

I have a datagrid that is populated from a SQLServer query that contains a few text fields in the query. When I try to export it to Excel, I get the following message

'Cell data too large'

I was assuming this was because the text fields contained too much data, but I have since setup an excel spreadsheet with the same query embedded into the sheet. That works fine and I don't get the error.

Does anyone know why, or a way to export the datagrid to excell without getting that message? Thanks

 

[ca8msm]

Can you post your code that you use to fill the excel file?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.