Memo Fields

[Almaw]

I tried to import more than 65k in to a memo field , I
could not import all the text data , what field type
should I use in order to have all my text in the field or
to have large amount of text in to the field.
any idea please help ?
Thanks! in Advance

 

[Bas Cost Budde]

I tried to import more than 65k in to a memo field , I
could not import all the text data , what field type
should I use in order to have all my text in the field or
to have large amount of text in to the field.
any idea please help ?
Thanks! in Advance

Can you use a subtable, with as many Memos as you like, to split the
incoming text arbitrarily?

.... but I don't think Access can handle this later on; unless you can
print the text on a report (in that case you just stream those subrecords).

What does this represent? Legal text, maybe?

 

[Tim Ferguson]

I tried to import more than 65k in to a memo field , I
could not import all the text data , what field type
should I use in order to have all my text in the field or
to have large amount of text in to the field.

The limit is not a feature of the memo field, which can happily go up to
the 2GB maximum that a whole mdb can hold.

You should look at your method of importing. The commonest limit to hit is
the 32K for an Access text box, but VBA strings also have a maximum size. I
think you can define a byte array as large as you like, but you'd need to
check the help files. Finally, if all else fails you can move large amounts
of text about in chunks using AppendChunk and GetChunk functions.

Hope that helps


Tim F

 

[almaw]

Thanks! Tim,
I am trying to import using the import wizard from access.
that is where I have a problem
Almaw

 

[Tim Ferguson]

I am trying to import using the import wizard from access.
that is where I have a problem

I just about never use wizards, so I can't help you directly there; except
to say that I'm surprised that it doesn't work properly.

Where are you importing from -- it is possible to link the table first and
then do a MakeTable query out of it? That would probably be my next try,
and finally a VBA routine last of all.

Best wishes


Tim F