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

what's there in blank cell when data is exported to excel frm db 1
export excel data to access table using ADO 0
Using quotation marks 4
Exporting nulls to Excel fails 0
Problem with deleting blank rows or last row 4
formula finds values in apparently blank cells 1
Want to blank some cells when an AutoFilter is active. 8
How to export unlocked cells to a row in a text file. 0

Top