I am using SQL to query a database (SQL 2000) in XL: -
sql = "SELECT InvMaster.StockCode, InvMaster.Description "
sql = sql & "FROM InvMaster "
sql = sql & "WHERE (((InvMaster.StockCode)=" & ActiveCell & "))"
It falls over because the ActiveCell is 'DYN/COM' (with a forward slash)
Does anyone know the syntax to get round this?
Going home now but will chack back Monday ; )