' ' is not a valid name - SQL in Excel

[Padawan018]

I am receiving this error when trying to convert an SAP data dump to a recordset in Excel via SQL. I have the named range set to the exact area so I don't have any extra columns.

Any help would be greatly appreciated.

Thanks
__________________
Don't feed my insanity!

 

[Fazza]

Hi, Padawan. Suggest you post the SQL. Maybe check all the headers first; and if the SQL doesn't reflect them correctly, post relevant information. F

 

[Fazza]

cross post http://www.mrexcel.com/forum/showthread.php?t=389953

 

[Padawan018]

Hi Fazza,

After importing the Excel data into Access I was able to determine that one of the headers contained periods. I removed the periods and the code worked beautifully. I am new to using SQL in Excel so I am still learning some of syntax issues.

Thanks,
Padawan018

 

[Fazza]

Good work, Padawan.

The period is the standard separator between table & field names. Such as,

SELECT MyTable.MyField, MyTable.AnotherField
FROM MyTable

So, the problems with a period within the field name are obvious. Usually with problematic characters, enclose the whole field name `like this`.

Also, enclose text 'like this'. Such as, untested

SELECT TOP 10 M.MyField, M.AnotherField, Sum(M.Value) AS [Cost]
FROM MyTable M
WHERE M.MyField Like '%bank%' AND M.ID_Num > 100
GROUP BY M.MyField, M.AnotherField
HAVING Sum(M.Value) > 10000
ORDER BY Sum(M.Value) DESC

HTH, Fazza