General discussion

  • Creator
    Topic
  • #2316442

    Access and SQL Server 6.5

    Locked

    by pjsinclair ·

    Is it Possable to extract data from a SQL server (then get rid of your SQL server) and use the data in Access. If this is possable could you inform me of how to do it.

    regards
    PJS

All Comments

  • Author
    Replies
    • #3380230

      Reply To: Access and SQL Server 6.5

      by sgt_shultz ·

      In reply to Access and SQL Server 6.5

      have you attached the database to access to have a look yet? how many tables? how many queries? how many users?

    • #2741641

      Reply To: Access and SQL Server 6.5

      by pancras ·

      In reply to Access and SQL Server 6.5

      You can attach access to sqlserver.

      File-Get external data- link. then use odbc type to connect to sqlserver.
      Link to all the tables.
      Then use maketable queries on all the linked tables to create native access tables.
      OR
      Simply use File-Get external data-import

    • #3390026

      Reply To: Access and SQL Server 6.5

      by techsupportspecialist ·

      In reply to Access and SQL Server 6.5

      Yes, it is possible.

      First of all, you need to have an ODBC connection set up. If you already have one, then you can skip to step 11:

      1) Open Control Panel
      2) Administrative Tools -> ODBC Data Sources
      3) File DSN Tab
      4) Add
      5) SQL Server
      6) Browse and create a DSN file anywhere
      7) Finish
      8) Create a description
      9) Select the SQL Server from the dropdown
      10) You will have to complete the rest of the wizard entering the correct information for your server
      11) Open the Access database that you want to create the tables in
      12) Right-click in the database window
      13) Import
      14) Select ODBC for Files of Type
      15) Browse for the dsn file you created
      16) From here, the rest should be self-explanatory

      I hope this helps. Good luck.

    • #3364483

      Reply To: Access and SQL Server 6.5

      by pjsinclair ·

      In reply to Access and SQL Server 6.5

      This question was closed by the author

Viewing 3 reply threads