Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009

    Unanswered: Automating Access Data Import Function

    Hi folks, I do have an SQL Database running on SQL Express.I would like to have data in some tables in the SQL Database imported into Access for validation and analysis purposes. I have done this through use of the ODBC.[and it works fine]. However i would like to automate the process of connecting and importing the data from SQL with just a click of a button. This is becasue the SQL DB is frequently updated . Is it possible to have this done with the command Button? I do not want my users to go through the process of ODBC connections.

  2. #2
    Join Date
    Sep 2002
    South Wales
    Rather than importing, have you considered linked tables?
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    Yup, linking the tables in would seem to be a much better way to go.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts