Hi everyone, and thanks in advance for your help.
I have a splitting headache dealing with queries in excel.
I have an apparently simple problem. I would like to trigger an Access query from Excel and subsequently to export the results to my spreadsheet. What is more, I would like to use a query with a WHERE clause depending on the value a cell contained in my Excel file, and I would like to trigger the query when the latter is modified. However, I had some issue to retrieve a piece of code that I can use to run this operation.
I have thought of using pivot tables in order to extract the data from Access and filtering them with VBA, but the performance of this operation is quite dissatisfying. I have also tried to use MS query, but I could not find a way to call my query from VBA and to custom it with the values contained in my spreadsheet.
Therefore, I guess that the sole viable way to solve this issue is to call the sql directly from excel, using the Access db as a target. I found ways of intercting with the db and to query it, but I have no clue on how I can customize my queries with values taken from Excel (queries called from excel are included in quotes). Do you have any other idea on how I could do that?
Thank you
I have a splitting headache dealing with queries in excel.
I have an apparently simple problem. I would like to trigger an Access query from Excel and subsequently to export the results to my spreadsheet. What is more, I would like to use a query with a WHERE clause depending on the value a cell contained in my Excel file, and I would like to trigger the query when the latter is modified. However, I had some issue to retrieve a piece of code that I can use to run this operation.
I have thought of using pivot tables in order to extract the data from Access and filtering them with VBA, but the performance of this operation is quite dissatisfying. I have also tried to use MS query, but I could not find a way to call my query from VBA and to custom it with the values contained in my spreadsheet.
Therefore, I guess that the sole viable way to solve this issue is to call the sql directly from excel, using the Access db as a target. I found ways of intercting with the db and to query it, but I have no clue on how I can customize my queries with values taken from Excel (queries called from excel are included in quotes). Do you have any other idea on how I could do that?
Thank you
