NULL and Empty String

  • Thread starter Thread starter MST
  • Start date Start date
M

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