Update Query / Import excel file with Null cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

good day all,

I use a form and command button to import and update my tlbcheckingaccount
from a file "export.csv". Is there a way that when I import the file, the
Debit & Credit cells that are null or have no value are imported with a
"0.00" instead of a null value?

i'm open to suggestions...

Thanks,

Brook
 
Brook

Take a look at Access HELP for the Nz() function (null-to-zero).

You can use this function to convert Nulls to anything, including a "0".

Regards

Jeff Boyce
<Office/Access MVP>
 
Brook

No. Import the data into a "temp" table. Create a query that parses the
data as it appends it to your permanent table. Part of the parsing you'll
be doing is applying the Nz() function. Maybe some of the other input data
needs "cleaning" before you can store it...

Regards

Jeff Boyce
<Office/Access MVP>
 
Back
Top