I have an update query, where by some of the data from Excel may contain zero length strings. When I run the query it overwrites any data in my access tables with the zero length strings.
I have tried various criteria in the query, but to no avail.
The query, updates from the imported table to the correct location in the target table, the criteria I have used are along the lines of
Like "*"
Is Not Null --- I now understand Null is not zero length string, but that should still check there is a value there?
I was thinking along the lines of the criteria checks there is some data in the source table before writing to the target table, is that right? Between the two above I fear I have something a bit more wrong than simply bad criteria?