How do I remove a null value while importing a excel document...

  • Thread starter Thread starter Guest
  • Start date Start date
If you are using the TransferSpreadsheet method, the only way to do it is to
go to the Excel sheet and set up Cell formatting for the colum with the nulls
in it to a number format that you want in Access. I have found that when a
cell in Excel is formatted as General and no data is entered, it comes in as
null. If you format it as a number and no data is entered, it comes in as 0.
 
Back
Top