mruff
asked on
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
cannoteidtquery.png
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
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thx a lot, strange I tried according the HowTo, with the EE--Exce-Articels ..
And got the message as attached
msquery.png
And got the message as attached
msquery.png
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.
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.
Otherwise, using your existing connection, enter your SQL statement in the box labeled Befehistext (Commend Text).
SELECT *
FROM AMOUNTFORMULA
WHERE Country = "France"