Query Column names with spaces in MS ACCESS

[dinilkarun]

we are able to query successfullu from a Column called "ParentUUD" (without space) using query

"SELECT Name FROM PartVersion WHERE ParentUUID='"+ str(lstUUID[0]) +"'"

we have a column whose name is "Parent UUID" (with space)
We are trying to query the column from PYTHON. we are getting error.I think the error is due to space in the column name.

Please tellus the method to query the MS access DB with column names with spaces.

[boblarson]

Encapsulate the field name in square brackets

[Parent UUID]

and in the future do not use spaces in field or object names as it simplifies things if you don't.

[LEwen]

Put [] around name.