View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Collard Mike Collard is offline
external usenet poster
 
Posts: 4
Default Access table exported to Excel does not preserve blank cells

Blank cells in an Access table when exported to Excel get
corrupted in some way so that the isblank() function
fails. If the apparently blank cell is highlighted, F2
pressed to edit and then the enter key pressed the cell
becomes truly blank.

Any ideas why this occurs and a solution?

Thanks

Mike Collard