Hidden Characters

[aziz rasul]

I am importing multiple spreadsheets using code in a single table in Access. When I create a delete query to delete all records that have nulls in the first three columns, it does not delete them all. It behaves as if some records have some data within the first three columns even though I can't see anything. I Trim the data before deleting.

Is it possible that the spreadsheets have some hidden characters? If so, is there any code that I can use within Access that would clear them before importing?

 

[KenHigg]

Sounds like you need to nz() it first and insert a zero length string if null. Then do the criteria on the existance of a zero len string. Or Simple test for both...???

 

[aziz rasul]

I will try that. Thanks.

 

[aziz rasul]

Ken, can you tell me how I would the Nz function? When I create a select query to establish the values that are NOT NULL, these empty values also appear.

 

[ghudson]

Is Null Or = ""

 

[aziz rasul]

Ah. I understand now.