NULL and Empty String

[MST]

Hi all,

I need to import data from a Excel file into Access Table.

A column in Excel file is empty and then imported into
Access Table it default becomes interpreted as NULL.

Any suggestion to get the imported field into Empty String
rather than NULL.

Thanks

 

[Ken Snell]

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 ("").