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

F

fBrush

How do I remove the Null Value when importing a excel document into Access
Database.
 
K

Klatuu

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.
 

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

How to remove a bracket that is itallicised for an entire document 1
Removing Line Numbers 4
How to remove external organization from Office. 0
Integrating information from Word to Excel (not mail merge) 1
Extract embedded excel file from word document 0
Embed the same Excel multiple times 0
Importing styles not updating document 1
Booklet in Word, Merge Directory from Excel 0

Top