Fill all Null Cells in Excel Spreadsheet with zeros or later in Access

[PeanutB7]

I am looking for a tip on how to fill all null cells in a large excel spreadsheet with zeros. I am loading the existing records into an Access database and I need to have the empty cells contain zero in order for calculations to function correctly. Is there an Access function that would update these like an Update Query. How would I make this function.

Thank you so much for the time.

 

[PHV]

In the VBA help file have a look to the Val and/or Nz functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JerryKlmns]

Or a default value of 0 for the fields of the table
containing numbers