VBA to import data into Access database

  • I need a vba code that can:


    1. create a connection to an access database
    3. creates the sql string using my variables
    4. exuctes that sql statement


    Anyone know how to do this or have a link?

  • Re: VBA to import data into Access database


    Google "excel vba sql import to access" and you will find a mass of sites dealing with this.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!