Results 1 to 2 of 2
  1. #1
    krkow is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    14

    Link the data from SQL server management studio to xls.

    HI,



    I would like to link the data from MS SQL studio to xls file.

    It will help me giving an overview on the data status what I have.



    How I can link few columns from MS Sql management studio 2008 with xls?

    When I update the data in SQL after refreshing I would like to see the results in xls.


    I have found in xls the filed called "Design", but in empty file It is inactive!

    BR

  2. #2
    krkow is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    14
    HI,

    I found how to link the data from server.

    Plase don't look into issue.

    br

Please reply to this thread with any new information or opinions.

Similar Threads

  1. ODBC link from Access to SQL Server changes to read-only
    By Petr Danes in forum Import/Export Data
    Replies: 1
    Last Post: 06-08-2011, 09:46 AM
  2. Replies: 1
    Last Post: 07-17-2010, 08:29 PM
  3. link sql server table to access
    By broken_ice in forum Access
    Replies: 0
    Last Post: 06-28-2010, 12:50 PM
  4. Data management and real time data
    By fsmikwen in forum Import/Export Data
    Replies: 1
    Last Post: 03-11-2010, 10:44 PM
  5. Replies: 2
    Last Post: 09-18-2009, 03:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums