SQL query in VBA

[dugdugdug]

In access I have the following make table query:

SELECT Table1.Field1 INTO Table2
WHERE Table1.Field1 Like "*SomeCriteria*";

How can I repeat this in VBA?

This does not work, something wrong with strings.

Thanks

Please Login or Register  to view this content.

[dugdugdug]

SOLVED!

Please Login or Register  to view this content.