Glad it worked for you. If the order is important, I'd add a field to the table, let's call it SortOrder, and open the recordset using it:

Set rstImports = OpenDB.OpenRecordset("SELECT * FROM ImportTables ORDER BY SortOrder")



Just opening a recordset on the table might get them in the right order, but I wouldn't count on it.