Migration ms access to SQLite

Migration data was hard but finished. My problem is to conversion working ms access code to working SQLite code.

So I need to call SQLite db from MS office over ODBC driver, and that option goes ok. Right now I have problem with selection few cell for ex. this code working ok with access db:

SQLQuery "SELECT [X] & 'adress:' & [Y] FROM [mytable] WHERE [Z]='"test"'", strFilePath, blnReturn, varArray

I get working version only with one selection: SQLQuery "SELECT [X] FROM [mytable] WHERE [Z]='" test "'", strFilePath, blnReturn, varArray

Any idea how to solve this issue? Thx.