I have to handle an amount of records and then insert them into a database. though, I have some stringvalues with the sign ' in it. This causes a runtime error (3075) while inserting the records into an SQL database.
Now I am looking for a quick way to see if there is a 'sign in the stringvalue and then change it by another value (perhaps a space). I want to manage this in my VB code if possible. (I'm building the insert query in my VB code, so I can manage this also in the query code if this is easier.)
Can someone give me a sample of code.