ASP reading database data, string getting cutoff

[tycaine]

HELP!

Ok, I'm running ASP and am accessing either an Access Database or an Excel Spreadsheet. When I call up a RecordSet of products and go to display the data I notice that the Description field is getting cutoff, right around 250-255 characters???

Now, this can't be a problem with the database can it? Not if it's happening with BOTH an Access and an Excel...

So what's going on? I'm using an ADODB.Connection, and it's pulling all the data fine, so why is the description field getting cutoff? Is it something I need to set in the RecordSet or what?

Can anyone help me out here please? I have a project to finish and I'm against the clock, and this has me baffled?!

Thanks in advance!

TyCaine

 

[onpnt]

take a guess that the field in access is not set to memo and you are including values longer then the 255 for a text field. at that point change to a memo type and also refer here for information on reading in values

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=80

_________________________________________________________
for the best results to your questions: FAQ333-2924
_{01001111 01101110 01110000 01101110 01110100}

http://www.onpntwebdesigns.com

[/sub]

 

[tycaine]

Ah-HA!!! Thanks a million 'onpnt'!! That solved the Access DB problem!

I KNEW it had to be something stupidly easy, I had just spent long enough banging my head against a wall trying to find it that I'd made myself stupid!

Ok, ok, ok, so that solves the accessing Access, is there a similar setting that needs to be tripped in Excel? Or is it just that Excel is not designed for what I'm trying to do and I should just convert everything over to Access?

Didn't want to as that involves shelling out a hefty sum ($320 last time I looked!) for Access, and I was really hoping to get by with Excel...

If anyone can help me with the Excel problem then it would be greatly appreciated.

Otherwise, guess I get to spend my hard-earned...

Later,
TyCaine