From Access to Excel having Error -2147217900 (Invalid SQL statement...

I have code for Office Automation. Data in Access turns into a chart in Excel. The code works normally as expected. But now I receive an error:

Error -2147217900 (Invalid SQL statement; expected DELETE, INSERT, PROCEDURE, SELECT or UPDATE, line 230

The code (part of it) is like this:

          Dim conQuery As String
110       conQuery = "[ChartDataOGAEpH]"
 
          ' Create recordset.
          ‘Debug.Print conQuery
220       Set rst = New ADODB.Recordset
230       rst.Open _
            Source:=conQuery, _
            ActiveConnection:=CurrentProject.Connection

Select allOpen in new window

Error when the SQL is:

SELECT Format([MätDatum],"Short Date") AS Registered, [Jäsprotokoll rader].OG, [Jäsprotokoll rader].SG AS AE, [Jäsprotokoll rader].pH

FROM Jäsprotokoll INNER JOIN [Jäsprotokoll rader] ON Jäsprotokoll.JäsprotokollID = [Jäsprotokoll rader].JäsprotokollID

WHERE (((Format([MätDatum],"Short Date")) Is Not Null) AND (([Jäsprotokoll rader].SG) Is Not Null) AND ((Jäsprotokoll.JäsprotokollID)=[Forms]![Jäsprotokoll historiskt]![JäsprotokollID]))

ORDER BY Format([MätDatum],"Short Date");

Although the output of the query is:

What am I doing wrong?