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.
Jump to PostEncapsulate 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.
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.
Put [] around name.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.