Datatypes huge data import.

H

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
 
H

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.
 
J

John W. Vinson

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

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).
 
Top