How to connect multiple Excel VBA files to Access Database via Command Button ?

  • Hello there !!!


    I am new to the forum and had a question regarding the connection between Acces and Excel. I have been using Excel for a while to do simple macros, but have not worked ever with Access. My excel is getting slow and I read that Access could be the way to go. I have tried to connect my Excel to Access directly, but it does not allow for the document to be xlsm format.


    Is this just me or is there a way to automatically connect Excel macros to Access. Please help !!!

  • Hello,


    Before drawing this kind of conclusion ...


    1. You should try to discover what makes your Excel ' slow ' ...

    2. Are you sticking to all the Golden Rules when using Excel as a Database ...?

    3. When it comes to working with multiple Excel files, have you considered Power Query ...?


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Should you be looking for inspiration ...


    1. Excel as a Database

    Excel/VBA Golden Rules. These Should NOT Be Optional


    2. Power Query

    https://www.myexcelonline.com/…kbooks-using-power-query/


    3. Connect Excel to Access

    https://www.exceltip.com/impor…s-database-using-vba.html


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • These help me a lot for future projects :)


    My problem per se is more that I have 3 files which are exactly alike the only difference is the data in them, but they have the same columns and everything. I need to combine to generate a report on a weekly basis. Though Access was the way but maybe Power Query is the way to go. I have to double check if my clients software has Power Query because if not it will not work on their end.


    Thanks for all your help !