.VALUE not getting exact data RRS feed

  • Question

  • Hello, 

    I got string values from a database, this database have invalid character on strings, so they are represented on the same way on excel (black diamond with question mark). 

    however when I try to pass that cell string.value to a variable it remove this symbol, so I cannot make update on the database. 

    If i use concatenate function, to create the query, it works perfectly, plus making copy/paste from excel to the SQL window, it goes perfectly also, the thing is when I tro to avoid this last step when I assign the cell value to a variable to be used as SQL query string. 

    It replace it with a Question mark. 

    Gilberto H.

    Tuesday, October 15, 2013 4:47 PM

All replies