SQL column name with blank space

[SONYFX]

I have a column name "City Name" in the table, however when I use the query:

"select * from table where City Name = 'NY'"

I get an error ([Microsoft][ODBC Excel Driver] Syntax error (missing operator) in query expression 'City Names = 'NY''. ), does anyone know how to fix this withput changing the column name?

 

[Snapster]

Select * from table where [city name] = 'NY'

 

[SONYFX]

Originally posted by: Snapster
Select * from table where [city name] = 'NY'

Thanks, but I still got an error, I think the SQL is thinking it needs two columns:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Excel Driver] Too few parameters. Expected 2.

 

[Drakkon]

Select * from 'TableName' where 'TableName'.'City Name' = 'NY'

 

[SONYFX]

Originally posted by: Drakkon
Select * from 'TableName' where 'TableName'.'City Name' = 'NY'

Still has error:

[Microsoft][ODBC Excel Driver] Syntax error in query. Incomplete query clause

 

[Drakkon]

hmmm thats odd...
you are working through an Excel sheet?

if so id read through : http://www.microsoft.com/technet/script...sources/officetips/jun05/tips0607.mspx

 

[torpid]

Use double quotes.

Select * from "Table Name"

 

[SONYFX]

Originally posted by: Drakkon
hmmm thats odd...
you are working through an Excel sheet?

if so id read through : http://www.microsoft.com/technet/script...sources/officetips/jun05/tips0607.mspx

Yes I am using Excel sheet, but the article didn't mention blank spaces in column, it's giving me headaches.

 

[Drakkon]

its because excel doesn't use column names, it uses the headers like A,B,C,D,E,F to define columns. and thats the way you have to preform lookups when accessing an excel "table".

 

[torpid]

Originally posted by: Drakkon
its because excel doesn't use column names, it uses the headers like A,B,C,D,E,F to define columns. and thats the way you have to preform lookups when accessing an excel "table".

That's not exactly true. See the article posted above, especially the part about the HDR variable.