I'm using ASP to pull database from an Excel Spreadsheet/Database. I'm connecting fine, I'm pulling the data fine, and everything is displaying great...
Except...
I have some fields in the Excel Spreadsheet that are quite long, descriptions of items and such, and I noticed that when being displayed the information is getting cutoff right around 255 characters...
Is this a limitation with Excel, or with ASP? Is there a way around this? Or (if the limitation is with Excel) should I convert the Excel data into an Access Database and would that show the long fields? (hope not, as it's about $320 right now!)
Please help!
Thanks in advance,
TyCaine
Except...
I have some fields in the Excel Spreadsheet that are quite long, descriptions of items and such, and I noticed that when being displayed the information is getting cutoff right around 255 characters...
Is this a limitation with Excel, or with ASP? Is there a way around this? Or (if the limitation is with Excel) should I convert the Excel data into an Access Database and would that show the long fields? (hope not, as it's about $320 right now!)
Please help!
Thanks in advance,
TyCaine