Symantek Q & A Conversion

dale131 · #1 (**permalink**) 08-10-2004, 11:47 PM

Have some Q & A data that I would like ot covert to MS Access 97. The files transfer, but I always have some of the entries cut off. Does someone know how to transfer the firle s and opoen up the Access data space to enough to accept 250 characters????

ronniethedodger · #2 (**permalink**) 08-13-2004, 12:04 AM

In the old days when I worked with Access, they had what they called a "memo" field datatype. It handled more than the text field could.

paulhiles · #3 (**permalink**) 08-13-2004, 05:39 AM

I'm a bit rusty on Access myself, but I'm pretty sure the memo datatype is still part of Access, at least up until Access 2000. The main use being for any long descriptions (anything over 255 characters). The actual limit is something like 64,000 characters!
A couple of downsides... one the memory overhead, and secondly, the data stored cannot be used in any sorting method.

ronniethedodger · #4 (**permalink**) 08-14-2004, 05:26 AM

... more appropriately, the memo datafield cannot be used as an index field. I forgot about that one.