When I import Excel files into Access, Access indicates that there is data (outside of the header row) in each cell even though the cells appear to be blank.
Any idea what would cause this type of issue?
Update: I've done a little more research since posting this question and now I'm wondering if it's because these cells have Null values as opposed to Blank values. From what I understand, these are two different things, but I can't seem to find any info on how to tell if a cell has Null value instead of Blank. Does anyone know?
Bookmarks