I am not sure if what I am trying to achieve is possible but here goes. I want to link to a group of foxpro free tables using VBA reason being the names and the number of tables I am linking to changes periodically so therefore I want to be able to link to whatever tables are within the directory. Can anyone help me?