+ Reply to Thread
Results 1 to 3 of 3

GET DATA SQL SERVER DATABASE (Read Only?)

  1. #1
    Registered User
    Join Date
    05-25-2021
    Location
    Denmark
    MS-Off Ver
    V.2210 Microsoft 365
    Posts
    10

    GET DATA SQL SERVER DATABASE (Read Only?)

    Hi, just a quick question. We do have a database in our company there contains all our drawing data.

    I have found out this week, it it pretty easy to make a get data from the SQL server thru excel.

    But my basic question is, is the connection Read Only if not , can i set it to read only, or do we need a new "Read only" user. I am not admin, and do not have the rights or the know how. I wish i can do it in excel.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,780

    Re: GET DATA SQL SERVER DATABASE (Read Only?)

    If you are using PQ to read the data from SQL, then there is no write back to the data base.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    05-25-2021
    Location
    Denmark
    MS-Off Ver
    V.2210 Microsoft 365
    Posts
    10

    Re: GET DATA SQL SERVER DATABASE (Read Only?)

    I do, Many times thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. macro to connect to sql server database and retrieve data
    By baluvasa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2013, 03:04 AM
  2. Read-only file on server. How many people can read at once?
    By Xx7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 12:10 AM
  3. Store excel data in a SQL Server database.
    By juniorcarls101 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2007, 05:54 PM
  4. [SOLVED] Problem importing data into sql server database
    By Me in forum Excel General
    Replies: 1
    Last Post: 01-26-2006, 09:55 PM
  5. [SOLVED] Problem importing data into sql server database
    By Me in forum Excel General
    Replies: 0
    Last Post: 01-26-2006, 04:20 PM
  6. [SOLVED] Retrieving data from database (MS Sql Server) to Excel
    By nwhan in forum Excel General
    Replies: 0
    Last Post: 07-22-2005, 05:05 AM
  7. MS Query to read data from SQL server stored procedure
    By Souris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2005, 02:06 PM
  8. [SOLVED] EXPORTING data from spreadsheet to SQL SERVER DATABASE
    By pmud in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2005, 08:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1