Need to remove special characters from strings/text - UtterAccess Forums - microsoft access strip special characters from a field

Category

Find and Replace special characters in a field - Microsoft Access / VBA microsoft access strip special characters from a field


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.