Datatypes huge data import.

[Harry-Wishes]

Hello

I have a collegue who has an access database who wants to import data that
exceeds 255 characters which I believe is the limit for text data. This
particular columm will probably contain paragraphs and paragraphs of text
depending on the record entered. Is there another datatype (like memo) that
can accommodate paragraphs of text in a cell?

Harold

 

[Harlan]

Harold,
for ACCESS 2007:

Number of characters in a Memo field 65,535 when entering data through
the user interface;
2 gigabytes of character storage when entering data programmatically



for ACCESS 98

I believe the user interface number was the same, but only 1 gig
programmatically.

 

[Klatuu]

I'm sure you meant 97, there is no 98

 

[John W. Vinson]

Is there another datatype (like memo) that
can accommodate paragraphs of text in a cell?

ummm... you answered your own question. A Memo datatype will do the job.

Create the table first, with a Memo field, and import into it, rather than
importing the file directly (Access will assign Text).