Hi,
I have a access database for simple accounts. I want to run the query from my excel sheet and get the result to that respective cells.
My database contains accounts name, type, credit limit, account receivable and account payable.
I can run the query to get any account details from access.
But i need that my manager don;t wana enter into database and run qry and he need get the details in excel sheet.
I had created the excel sheet. that contains account type, credit limit,account receivabale and payable. Additionally i have the dropdown box to select the account name. Actually now i linked with another sheet that gives the data to dropdown. But i need to link with database table. Once the data is selected from dropdown the details of account type ,credit limit, account receivable and payable should change.
Imthiyaz