hard code text values

[trustsun]

I am importing text-delimited data from a note pad. How could I make sure the values are text? I've tried all sorts of expressions but to no avail. Also, some have spaces in them and will not insert or join with another query.

I think this only removes spaces: Trim([Field1]). I need to make sure there are no spaces, omit nulls and only text.

Thanks

 

[HandsOnAccess]

Use Len(Trim([Field1])),
If Len(Trim([Field1])) = 0 Then there is no text and you can omit such data.

Further you can also use Val([Field1]),
For a text data, Val([Field1]) will return 0.
Example
Val("15A") is 15
Val("ABC") is 0
Val("A7B") is 0

Hope this helps you....
Regards,