$$Excel-Macros$$ access query

Dear Group Members, This query is related to MS Access 2007. I hope you will be able to solve it. I have created the following table in Access. Dealer Code Dealer Name RDSSch-1 Payout Sch-2 Payout A ABCDEF

Re: $$Excel-Macros$$ access query to run into excel

Dear Sara, Please try through below link http://quickvba.blogspot.com/2008/04/query-access-from-excel.html http://www.excelvbamacros.com/p/access.html On Fri, Oct 28, 2011 at 4:46 AM, Sara Lee wrote: > hey > > is there a macro to run access query inside excel 2007. and excel data > should refr

$$Excel-Macros$$ access query to run into excel

hey is there a macro to run access query inside excel 2007. and excel data should refresh with any change in access query data. -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pr

$$Excel-Macros$$ Access query-very urget please help

Hi All, I have a small query in MS Access. I have 2 tables 1.Test1 2.Stable The title column in Test1 table have few titles which are same as Title column in STable. I want to lookup the title in STable and update the Scolumn in Test1 Table with Yes or No. That is if the Title is present in STa