none
Microsoft Query Loses Command Text RRS feed

  • Question

  • I have Excel spreadsheets with data connections created through the Microsoft Query ODBC.  Some go to a SQL Server ODBC some to other ODBC.  I have many of them where after saving and reopening the data connection is still there by the SQL statement is missing in the command text of the connection properties and I will not let you edit it and put it back.  This is happening on more than one computer, user account and data connection.

    Image

    Monday, March 18, 2019 8:08 PM

All replies

  • I have the same issue - but cannot find that anyone has responded to these types of questions.  Have you had any luck?

    Tuesday, November 5, 2019 8:19 PM
  • I have the same issue as well, anyone has luck on finding a solution?
    Wednesday, May 6, 2020 12:08 AM