No REPLACE function in MS Access ODBC driver when trying to replace characters in custom mapped field data for data exports
Author
Thread
AuthorRowan Drew 8th April 2015
When the MYOB Retail Manager adaptor is being used to export product data from Retail Manager's underlying database, there was a requirement to replace the space characters in the product's description with dash characters when being mapped to the "SEO Item ID" field. The problem is that when the database that Retail Manager's data lives within is an older version of the Microsoft Access database, the ODBC driver used to obtain the data does not support the REPLACE function in SQL queries, which makes it impossible to replace characters with other characters.
8th April 2015