insert statement

[myetteski]

Help! The following statement causes compile error: expected end of statement

INSERT INTO table1 SELECT * FROM table2 WHERE field = '" & variable & "'

[HarryW]

I'm not quite sure what that says cos it's real small :)
Which is it?:

" ' & variable & ' "

' " & variable & " '

' ' ' & variable & ' ' '

I've spaced the speech marks/apostrophes out so you can see the difference.

I would have expected this:

" ' " & variable & " ' "

If you're setting up a string to use as an SQL statement.