run time error 3061 - too few parameters. expected 3

[Erick]

Can anyone spot what is where I am going wrong with this code. It is coming up with 'run time error 3061 - too few parameters. expected 3' error.

It is just supposed to create a table (which it appears to be working fine) and then insert some simple data into it.

Sub Temp()    Dim MyDB As DAO.Database
    Set MyDB = CurrentDb()
    
    MyDB.Execute "CREATE TABLE tempTable (F1 STRING, F2 INTEGER, F3 STRING, F4 STRING);"
    MyDB.Execute "INSERT INTO tempTable (F1, F2, F3, F4) Values (a, 0, b, c)"
End Sub

Greatly appreciate all your help in advance

 

[Joe4]

Which line throws back the error?

I see one thing I think may be wrong. If a,o,b,c are literal text values, they need text qualifiers, i.e. maybe something like:

MyDB.Execute "INSERT INTO tempTable (F1, F2, F3, F4) Values ('a', '0', 'b', 'c')"

Note. You may have other errors too. I have not used this method to create DAO temp tables. I am just pointing out something that sticks out to me.

 

[Erick]

Thanks for the reply Joe.

It was just as simple as text qualifiers as you pointed out. Sometimes it's those simple things that trip me up because I was looking for a more complex solution.

Thanks again