Search results

How do I search for a value in all tables? Does anyone know how I can do it? I am just for example searching for a value: 393592 in all of the tables which is in a database and make it display which table it's in :\ Thanks for any help :D

Does anyone know how to do this? I Need to make a macro that will import all excel documents in a folder into a database, with the name of the table as the value in 1 of the boxes inside the excel document (So maybe A3 location). Please help. Thanks!