I have a large table with information about files on an AS/400, I have the file name, desc and field names. I want to be able to create a new table at each change in file name, adn have the table name corespond to the file name. So I am looking for a way to automate this so I do not have to enter each table name and run a make table query. Is there some code I can use that will look for each change in table name and create a new table? I hope I did a good job of explaining what I am trying to do.

Thanks in advance for any help

I would create a query to get all the unique file names.

Then open as a recordset and loop through the records and run a make table query. You could even read the fileds names to build the query.

Why would you have duplicate tables?

Did you get it working?