Posts by mshackwho

    Re: Access data to Excel through Excel VBA


    Change " [FONT="Calibri"]Provider=Microsoft.ACE.OLEDB.12.0 " to use it for .accdb extension[/FONT]



    Code Credit: Trevor G


    Hi,


    I am looking to get the query table data into excel new sheet using excel vba.


    I only manage to find a way to do it by inserting the module in access vba.


    As it is require to insert data from excel to access table and then pulled back the query table result back to excel, if I could get it all in excel I could do a call macro to run all process from one place.


    Any help is appreciated.