You cannot convert values as you import them. But you can manipulate them
after you have imported the values.
Import into a temporary table, and then use an append query to copy the data
into a permanent table. In that append query, use a calculated field to
convert a Null value into an empty string ("").

Signature
Ken Snell
<MS ACCESS MVP>
> Hi all,
>
[quoted text clipped - 7 lines]
>
> Thanks