error importing data

L

lula

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

KARL DEWEY

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

lula

thank you... It worked great.


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top