Make table query - sql

[Spelthorne1]

I have an make table query where i would like the users to choose a name for the table in the backup database.

Dim strtbl As String

strtbl = "WC26Apr"
Set qdf = db.QueryDefs("Backup")
        strSQL = "SELECT WC16Feb.*, * " & _
                     "INTO  & strtbl &  IN   & T:\data.mdb  " & _
                      "FROM WC16Feb;"
qdf.SQL = strSQL

 

[Pat Hartman]

The syntax is not correct.

Dim strtbl As String

strtbl = "WC26Apr"
Set qdf = db.QueryDefs("Backup")
strSQL = "SELECT WC16Feb.* " & _
"INTO " & strtbl & " IN " & " T:\data.mdb " & _
"FROM WC16Feb;"
qdf.SQL = strSQL

 

[Spelthorne1]

The syntax is not correct.

Thanks pat.
I didnt realise that i'd submitted the thread. I was gonna write a little more explanation rather than just demanding an answer!! Its annoying when theres just a ' missing. Its good to have a fresh eye looking over the code - i couldnt see for trying!