+ Reply to Thread
Results 1 to 2 of 2

How to change query or connection properties in excel

  1. #1
    Forum Contributor
    Join Date
    08-18-2018
    Location
    Canada
    MS-Off Ver
    365
    Posts
    151

    How to change query or connection properties in excel

    I created an excel and linked it in Access database. Before I'm using excel 2013 and when I linked it in excel connection properties has been added however when I change to excel 2016 query properties is added. Can I change it to connection properties? It is grayed out and I can't change it. See images attached. tia.
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    08-18-2018
    Location
    Canada
    MS-Off Ver
    365
    Posts
    151

    Re: How to change query or connection properties in excel

    I found out what should we do. We need to create new connections thru Data, Existing connections, Browse for more and search for your database. This will create an connection, instead of query in excel.

+ 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. Change workbook connection from OLEDB to Database Query?
    By walterbyrd in forum Access Tables & Databases
    Replies: 9
    Last Post: 09-25-2019, 08:53 PM
  2. VBA Change WSID in Connection String for Query Table
    By KMJG in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2014, 02:03 PM
  3. Replies: 0
    Last Post: 05-29-2013, 10:28 AM
  4. [SOLVED] Programatically changing MS-Query properties within Excel.
    By Greg Glynn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-30-2006, 11:35 AM
  5. [SOLVED] Change Connection of a Query
    By Jean-Francois in forum Excel General
    Replies: 1
    Last Post: 10-05-2005, 08:05 PM
  6. Trying to read extended properties on Excel OLE DB connection
    By Andy S. in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-24-2005, 03:05 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