The code that you put in the CommandText gets executed by the database engine, so you can include any functions that are supported by the database engine. Obviously Replace is not supported by the Jet OLEDB provider for Excel.

__________________

2007, 2008, 2009, 2010

Why is my data not saved to my database? | Communicating between multiple forms
MSDN: Data Walkthroughs | "How Do I?" Videos
My Blog: Custom Events | Dynamic GDI+ Drawing