Access table exported to Excel does not preserve blank cells

M

Mike Collard

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using quotation marks 4
formula finds values in apparently blank cells 1
Macro to transpose data to fill blank cells in table 5
PivotTable (blank) cells won't display NULL! 3
Blank vs empty cells 5
Appending Excel file to an Access table 1
Why do blank fields, when exported to Excel appear not blank? 5
Replace null string with blank cell 2

Top