I am attempting to use an update statement and oledb to write to my file but am having an issue passing empty values in the where clause of the update statement. The where clause is based on values from the file I am reading and some of them are blank sometimes.
How can I set values in my update statement's where clause that are essentially blank that excel will recognize as being empty? Please let me know if any clarification is needed or if this is even possible at all.
I have tried just using '' as the value if the cell being read is empty, but it does not work.
Thank you for any advice or suggestions.