Problem writing to Excel

My [vb6] app inserts data into an Excel spreadsheet but it looks like there's a limit of 255 chars per field

Why is that?
I can paste more than that directly into Excel!

I need to have about 300 chars or so.





(Please don't say use a database - I know I can use a database; and I know a database would be better. I am using a spreadsheet because that's what the 'customer' wants! )

what code are you using to insert the data?

Quote:

---

Originally Posted by Guru

My [vb6] app inserts data into an Excel spreadsheet but it looks like there's a limit of 255 chars per field

Why is that?
I can paste more than that directly into Excel!

I need to have about 300 chars or so.





(Please don't say use a database - I know I can use a database; and I know a database would be better. I am using a spreadsheet because that's what the 'customer' wants! )

---

This may help (or not): http://support.microsoft.com/kb/213841

Tysons link should solve it and also explain the difference. Good find :)

Thanks for the replies... I've been a bit tied up with something else today but I'll check it out when I get a chance.

Thanks