function in command text - ASP.NET

[casper]

can you really have a function in the command text?

I have a line of code as below:

oCommand.CommandText = "UPDATE [SHEET1$] SET TEST = replace([test], '~', ';')"

I keep getting an error "Undefined function 'Replace' in expression"

 

[jmcilhinney]

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.

 

[jmcilhinney]

This is a data access issue so it belongs in the Data Access forum. Please post in the most appropriate forum, not just the first one. Moved.

 

[cjard]

List of all vba functions:
http://office.microsoft.com/en-us/access/HP011353121033.aspx

List of functions allowed in "safe mode":
How to configure Jet 4.0 to prevent unsafe functions from running in Access 2003

If these don't apply to your version of jet, you can consider stating your version of jet next time you ask a question