Hello,
I trying to use an ODBC stage with a Access Database. The connection is OK, but when i try to make a query on one ODBC access table, it dosen't work.
In fact, in access database, table have some column name composed by two word like this : tableA.purchase order.
How can i read this table ?
Thanks for your help !
ODBC stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Because the table name contains a space, the entire table name or column name must be quoted. If one were to follow the ODBC standard, which was written by Microsoft, one would use double quote characters, for example "TableA"."purchase order" - if that doesn't work, because Microsoft does not follow their own rules, use backtick characters, for example `TableA`.`purchase order`.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.