+ Reply to Thread
Results 1 to 1 of 1

Connection string for MS Query

  1. #1
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2003
    Posts
    18

    Connection string for MS Query

    Hi all !

    I have defined 3 tables within the excel file, all in different tabs.
    The 3 tables are used for querying using MS Query. (I have not used Access as source)

    I need to distribute this file, so every time I use it on a new computer, I have to modify the connection string and the query.
    Is there any way around this problem ?

    Connection String.PNG
    Last edited by kravi88; 06-05-2014 at 10:44 AM.

+ 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. Excel External Connection Dropping Password from Connection String?
    By mar0isa in forum Access Tables & Databases
    Replies: 1
    Last Post: 03-06-2015, 10:35 AM
  2. Using Macro to Reset MS Query Connection String
    By KyleForgie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2014, 07:34 PM
  3. [SOLVED] Using Cell Value In Web Query Connection
    By rlee12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2013, 03:56 AM
  4. MS Query ODBC Connection
    By mlr0911 in forum Excel General
    Replies: 2
    Last Post: 04-24-2008, 08:52 AM
  5. Web Query using ADO(?) connection
    By reloader in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2006, 05:25 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