Excel VBA, Excel Sheet and Access table RRS feed

  • Question

  • Hi guys, 

    was wondering does anyone have example of how I can use excel vba to upload a workseet into access table ?


    how use excel vba to import access table into excel worksheet ?

    Could these two procedures be done via excel vba ?

    Thank you


    Sunday, July 10, 2016 2:25 PM


  • Hi Johnseito,

    please visit the link below will give you an example of import/export data from Excel to Access and Access to Excel using Excel VBA.

    Import or Export Data from Access to Excel using ADO

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.



    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, July 11, 2016 5:33 AM