Need null value cells to show blank in a database linked to excel

[Guest]

I have linked a database to an excel spreadsheet. I have blank cells on my
spreadsheet that are showing a "Zero" in the database field. How do I change
it so the fields will show blank and not a zero?

 

[John Nurick]

Are you certain that the cells in the worksheet are blank? Remember that
there are at least two ways to get Excel to display zeros as blanks.

 

[Guest]

Yes, the cells are empty and the zero values block is not checked in the
options.

 

[John Nurick]

I've never seen or heard of this happening.

Try this:

1) Open Excel and create a new workbook.
2) In Sheet1, Column A, type

ID
1
2
3
4
5

3) In Column B, type
TextField
AA
BB
CC
(leave this cell empty)
EE

4) In Column C, type
NumberField
1.1
1.2
(leave this cell empty)
1.4
1.5

5) Save the workbook and close Excel.

6) In Access, use File|Get External Data|Link to link to the Excel
sheet.

What values appear in the two empty cells?

 

[Guest]

Yes that worked like it should have. There must be something going on with
the excel spreadsheet formats that I am not aware of. I am not the author of
the spreadsheet so I'm not sure what they did. I belive I will recreate the
spreadsheet from scratch and start there. Thank you for the help.