I'm sure this has been answered but I can't think of the right keyword to search for. I'm transferring data between tables inorder to normalize an old db and basically I have a
docmd.runsql("insert into .... values (... ' " & rs.fields("fieldname") & " ' ...
but a lot of the records in 'fieldname' have commas or maybe other special chars and so the statement fails. Are there any functions that will remove the special characters or escape them if that's the right word. Thanks.
docmd.runsql("insert into .... values (... ' " & rs.fields("fieldname") & " ' ...
but a lot of the records in 'fieldname' have commas or maybe other special chars and so the statement fails. Are there any functions that will remove the special characters or escape them if that's the right word. Thanks.