' ' is not a valid name - SQL in Excel

F

Fazza

MrExcel MVP

Joined

May 17, 2006

Messages

9,368

• Jan 11, 2010

• #2

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

 

Upvote 0

F

Fazza

MrExcel MVP

Joined

May 17, 2006

Messages

9,368

• Jan 11, 2010

• #3

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

 

Upvote 0

Padawan018

Board Regular

Joined

Sep 29, 2006

Messages

63

• Jan 11, 2010

• #4

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

 

Upvote 0

F

Fazza

MrExcel MVP

Joined

May 17, 2006

Messages

9,368

• Jan 11, 2010

• #5

Good work, Padawan.

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

Code:

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

Code:

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

 

Upvote 0