Loop thru tables and use SELECT INTO 1

[evalesthy]

I would like to loop thru a group of tables and copy each one using SELECT INTO. How would I replace table name with a string? For example in: db.Execute "SELECT Employees.* INTO [Emp Backup] FROM Employees;" how would Employees and Emp Backup be replaced with strTbl and strNewTbl - I can't seem to get the syntax right.

 

[oharab]

Try
db.Execute "SELECT [" & strTbl & "].* INTO [" & strNewTbl & "] FROM Employees;"

Ben ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------