how to read a paragraph into an access field?

[kyledavis]

I was wondering how it is possible to have a paragraph longer than 256 in access? Can I write my paragraph in an excel file and reference the file in access?

 

[statik213]

Originally posted by: kyledavis
I was wondering how it is possible to have a paragraph longer than 256 in access? Can I write my paragraph in an excel file and reference the file in access?

Use the data type 'memo' instead of text. This should give you plenty of space, it is a variable size field, not sure what it's maximum size is, probably at least 64k.

 

[AEnigmaWI]

just be careful that you don't end up w/ huge mega size DB files full of memo fields... it can make her stuff super slow if you are using old hardware etc 😛

referencing external file w/ hyperlink can also work depending on what kind of output you are trying to generate from the base table.. ie if it's displaying in a browser etc. you could just hyperlink to external txt files or something.. if you are using internal form reporting i guess the memo would be the way to go tho.

 

[kyledavis]

so I if I link to an external text file, how will I get that text to show up on my webpage?

 

[kyledavis]

any ideas anyone?

 

[statik213]

Originally posted by: kyledavis
any ideas anyone?

what's the problem with using a memo field anyway? Don't worry too much about overusing it, you shouldn't see problems until you start having millions and millions of rows; I suspect you won't have as many records in your table.

 

[EagleKeeper]

When I have used Memo fields (to store War & Peace), I will keep them in a seperate table and link an index to the relevant record.

Memo fields can store up to 32K characters.