Search results

Thank you all for replying to my post so quickly. After figuring out how to search a folder and its subfolders for .mdb and .accdb files, I got around to actually importing tables from them. I ended up using a solution looking almost exactly like boblarson's and it works perfectly so far...

Thank you so much for your reply, TJPoorMan. I definitely needed another perspective on this and I think I can make your solution work for what I need. I won't be able to try this out until tomorrow, but thank you once again for your help.

I figured out how to import a table using VBA like so: Private Sub Command0_Click() Dim dr As String dr = Dir("F:\SomeFolder\*.mdb", vbDirectory) DoCmd.TransferDatabase acImport, "Microsoft Access", "F:\SomeFolder\" & dr, acTable, "Table", "Table2" End Sub This was just a test...