Hi All
I am working on a Excel VBA proj. I ahve to insert some records in the Access Db. Right now I am forming the query as a string, creating a connection and executing the query
Eg:
"Insert into Table1 values ('A','B','Comments')"
Now if the comments or any other field contains a single quote('),my query bombs.
I read about parameterized queries,just like a PreparedStament query in java,can similar thing be done inVBA. An example would be highly appreciated.
Thanks
Jhakda
