TechRepublic|Forums|Web Development

Web Development

General discussion

  • Creator
    Topic
  • September 8, 2003 at 3:10 am #2316442

    Access and SQL Server 6.5

    Locked

    by pjsinclair · about 18 years, 8 months ago

    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

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • September 10, 2003 at 2:42 pm #3380230

      Reply To: Access and SQL Server 6.5

      by sgt_shultz · about 18 years, 8 months ago

      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?

    • September 16, 2003 at 1:33 pm #2741641

      Reply To: Access and SQL Server 6.5

      by pancras · about 18 years, 8 months ago

      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

    • September 29, 2003 at 7:27 am #3390026

      Reply To: Access and SQL Server 6.5

      by techsupportspecialist · about 18 years, 8 months ago

      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.

    • October 15, 2003 at 4:48 am #3364483

      Reply To: Access and SQL Server 6.5

      by pjsinclair · about 18 years, 7 months ago

      In reply to Access and SQL Server 6.5

      This question was closed by the author

  • Author
    Replies
Viewing 3 reply threads