Importing excel file

Hi Elsie, thanks for your query. You can't stop blank cells being imported during the importation procedure, I'm afraid. Best practice is to deal with them in Excel first (say, by replacing them with NA) and then import the data. This is all part of the normalisation of data that you should carry out when you move data into your Access database; blank cells can cause errors, particularly if fields in your table have been set to refuse Null values, so "clean" the data before you import it.

Hope this helps,

Anthony