excel - 选择语句包含拼写错误或缺失的保留字或参数名称，或者标点符号不正确 - VBA Excel

Question

strQuery1 = "SELECT 'Health Start Lite' AS HSL_RAW_ProductName, Max(HSL_RAW.[DateCreated]) AS MaxOfDateCreated," & _
"HSL_RAW.[Premium], Last(HSL_RAW.[FirstName]) AS LastOfFirstName, HSL_RAW.[LastName]," & _
"HSL_RAW.[EmailAddress], HSL_RAW.[MobileNumber], HSL_RAW.[Partner], Last(HSL_RAW.[Stage]) AS LastOfStage" & _
"FROM ...

Answer 1

LastOfStage 和FROM 之间缺少一个空格。应该是:

 "... AS LastOfStage" & _
 " FROM ..."

注意 FROM 之前的空格。