I have a number of queries that I run in sequence. E.g.
strSQL1 = "SELECT * INTO TEST2 FROM TESTIAT;"
strSQL2 = "SELECT * INTO TEST3 FROM TESTIAT;"
strSQL25 = "SELECT * INTO TEST25 FROM TESTIAT;"
I run them one by one using:
I would like to change the DoCmd.RunSQL lines using a loop. But I keep on running into errors. Please help.