Queries and Insertion with SQL in VBA for Access

[Overkill32]

I'm currently trying to automate a process to do queries and inserting records in the Database i'm using. Can someone help me with the syntax to achieve these request? I did a simple Query with the editor using SQL code and I'm not able to repeat the same process using VBA. Here is the snipet i did "

SELECT Caracteristic, Price FROM Table WHERE Caracteristic= "0098" ;

 

[Joe4]

The Double Quotes can often be problematic in VBA, because they are often treated as text qualifiers instead of literal values. I often use the ASCII representation to return those in VBA (CHR(34)), i.e.

Dim mySQL as String
mySQL="SELECT Caracteristic, Price FROM Table WHERE Caracteristic=" & Chr(34) & "0098" & Chr(34)

Was that the problem you were having?