Exporting From Access To Excel

[cameric]

Dears,

I have a little problem, but I'm sure one of you would be able to solv
my problem.

I'm exporting a query (coming from a table) from Access to Excel, bu
my problem is that when there's no value, there's nothing in the cell.
But I would like to get 0 as no value in the cell.
It's because this sheet is used daily to make sum's and I don't want t
fill all the cell with zero.
I'm sure it could be done automatically in excell or when exportin
from Access.

Thanks for your help.

Cameri

 

[Job]

Hi Cameric,

Take a look at the asap utilities addin. It has a fill function tha
will fill all of the blank cells in a selection with whatever yo
choose. http://www.asap-utilities.com/

HTH,

Jo

 

[cameric]

Great seems to be really cool.
Thanks for the hint