Solved

excel cannot edit sql in connection

Posted on 2014-04-14
5
720 Views
Last Modified: 2014-04-20
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
cannoteidtquery.png
0
Comment
Question by:mruff
  • 3
  • 2
5 Comments
 
LVL 16

Expert Comment

by:Jerry Paladino
ID: 40001167
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).  

SELECT *
FROM AMOUNTFORMULA
WHERE Country = "France"
0
 

Author Comment

by:mruff
ID: 40001270
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?
THX
0
 
LVL 16

Accepted Solution

by:
Jerry Paladino earned 500 total points
ID: 40001560
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.
EE---Excel-Query-with-MS-Query.pdf
EE---Excel-Query.xlsm
EE-Excel-Articles-2014-03-02-18..xlsb
0
 

Author Comment

by:mruff
ID: 40003729
thx a lot, strange I tried according the HowTo, with the EE--Exce-Articels ..
And got the message as attached
msquery.png
0
 
LVL 16

Expert Comment

by:Jerry Paladino
ID: 40003891
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.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now