There are some special characters in this field e.g. (-,/&_\!#). How can I remove these special characters using a single query? This thread is locked. 'Source: Dave Hargis, Microsoft Access MVP (klatuu) Dim lngCtr As Long.
I have the system setup to import a erdves.info file into a table called tblDmnLst. It contains a column called "NitchMarket" (datatype.
We have a spreadsheet that i upload onto a table, i use on of the fields to build a file path but if there is a special character it causes problems.