• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1123
  • Last Modified:

excel cannot edit sql in connection

Dear experts,
I am adding a data connection in excel to another excel file, worksheet
both excel and work sheets are not protected
I cannot edit the SQL query
please see also the attachment
  • 3
  • 2
1 Solution
Jerry PaladinoCommented:
The way you have established the connection using the ACE OLEDB provider, the SQL is edited in the Command Text (Befehistext) box.  The Edit Query (Abfrage bearbeiten...) button refers to a connection using ODBC and MS-Query.   If you want the MS-Query SQL editor then reestablish the connection using...   DATA / GET EXTERNAL DATE / From Other Sources / From MS-Query.    

Otherwise, using your existing connection, enter your SQL statement in the box labeled Befehistext (Commend Text).  

WHERE Country = "France"
mruffAuthor Commented:
Hi I do not get it
How Do I do that:
 MS-Query SQL editor then reestablish the connection using...   DATA / GET EXTERNAL DATE / From Other Sources / From MS-Query.
In the connection dialog box I select New Source->DB connection wizard opens->More Extended->I have a list of driver
I select e.g. micorosft ole for ODBC ...But then I CANNOT connect to another excel
So How Do I get to from MS-Query?
Jerry PaladinoCommented:
Three attached files that should help...  

The PDF file has a series of screen shots
The EE-Excels Articles is the datasource
The EE-Excel Query file is the file that contains the MS-Query that reads the EE Articles data file.  

The connection string in this file is pointing to the file on my "Desktop" on my PC.  You could replace that directory with one on your PC and this sample should work for you on your PC.
mruffAuthor Commented:
thx a lot, strange I tried according the HowTo, with the EE--Exce-Articels ..
And got the message as attached
Jerry PaladinoCommented:
Did you start fresh and attempt to recreate the steps in the how to PDF file?
If so, at what step in the PDF screen shots are you receiving this message?  

I just started from scratch and recreated the query with no problems so I don't know where you are experiencing this message.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now