column name with space in access

nkramanmca · January 24th, 2005, 03:48 AM

hai everybody,

in my table there is a space in column names. how i can retrieve that field using select query. I don't want to put select * from tablename. i want to retrieve like this select column1,column2 from table name. help me

thanks in advance

Kalyanaraman Narayanan

Braxis · January 24th, 2005, 04:13 AM

As you've discovered, spaces in names cause problems.

The ideal solution would be to remove them! Assuming you've gone too far to do this without loads of work, just wrap the field names in square brackets.

Code:

SELECT [table 1].[field 1]
FROM [table 1]

Brian Skelton
Braxis Computer Services Ltd.