Custom access query from inside exce?
Posted on 2011-09-16
I'm trying to do a macro, where on click a query is sendt to a access database to retrieve certain fields of data. For example:
Running the macro would then automaticly run the query:
SELECT RAWDATA.Names AS PersonNames, RAWDATA.Age as PersonAge
The reason for this is that the database and the fields change names constantly. And it would be a great help if you could simply type in the name of the database, the table and the two column names and the data was automaticly imported
Is having custom queries in excel even possible?
I hope some of you wizards out there have a suggestion! Thanks in advance!