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


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