locked
how can i cope with spaces in table names? RRS feed

  • Question

  •      I have several MS Access files to work with, but the problem is table names contain spaces. SELECT statements seems to be not working with these names..

    -->>  SELECT JointElem, GlobalX, GlobalY, GlobalZ FROM Objects and Elements Joints

    How can i fix this, or make it working??

     

    Wednesday, July 11, 2007 7:09 AM

Answers

  • Enclose the name in square brackets:  [Objects and Elements Joints].
    Wednesday, July 11, 2007 8:56 AM