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>
 
Thank you... so this will convert the null to zero upon import?

Brook
 
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>
 
You must log in or register to reply here.

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

Update query for null values in multiple lines 2
Help with importing... 8
Update query - fill in null field with value from record above 3
Import 4 Different Excel Files from One Folder 0
Join on an Empty Field 2
update query avoiding null values 2
update query with summary 2
NULL problem with Created table 1

Back
Top