Importing text files containing large text

S

Sharp

Hi

I'm using Access 97.

I'm trying to import a text file as a table.
One of the columns contains data of type "text".
The text can be over 255 characters - problem!
Access will truncate the text if it is over 255 characters.
Is there a solution to this problem?

Cheers
Michael
 
6

'69 Camaro

Hi, Michael.

Use a memo field instead. Memo fields can hold much more than 255
characters. In Access 97 and after, one can paste in 65,535 characters in
the user interface or store up to 1 GB of data per record. That should be
plenty.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Top