error importing data

[Guest]

hi... I have a silly question, but I'm quite new in programming.

While importing some data from Word into my database I have an error message
when one of the formfields that I'm importing doesn't have information.

I'm importing it in a table and that specific field is a memo field, as most
of the times it's filled with a lot of information.
I openned the word file and write in that formfield just a space, and I
could imported fine afterwards.

but, is there any way I can set up that field as memo but also to allow
null??

I'm not sure if I explained myself very well, but if anybody understood and
knows what to do, please let me know. I appreciate all your help in advance.

 

[Guest]

Open the table in design view and check the Required & Allow Zero Lenght
properties.
Required should be No.
Allow Zero Lenght should be Yes.

 

[Guest]

thank you... It worked great.

Open the table in design view and check the Required & Allow Zero Lenght
properties.
Required should be No.
Allow Zero Lenght should be Yes.