Export date problem

P

Patrick

Hi guys!!

Im trying to export to an Access table a bunch of fields
from a FileMaker Pro database(Ver.6). Some of those fields
are date fields.

My problem is that i need to export the date fields even
if they dont have any data into them. But Access table
dont seem to accept empty dates. I know that you can force
a text field in Access to take empty data.

Is there a similar way of doing things like that but in a
date field.Keep in mind that every thing is done from the
file Maker Pro side....

Can anyone help me out with this!!

Thanx in advance for any help or advice you might tink of.
PAtrick
 
N

Norman Yuan

Access (and most database allow a field to have null value, In your case,
whether the date field allow empty date (null) or not depends on the table
design. Go to design view of the table, highlight the field and then set
"Required" property to "No".
 
Top