Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    280

    Unanswered: how do I make fields name with space in between...

    recognize the fields in the table.

    Here is my SQL statement:

    INSERT INTO Test2 [Chart Number], Name, [Entry Number]
    SELECT Test.[Chart Number], Test.Name, Test.[Entry Number]
    FROM Test;

    I'm having an error on this statement because there is spaces between the field name. How do I make this statement work for it to recognize the field name in the table

  2. #2
    Join Date
    Apr 2003
    Location
    Santa Barbara, CA
    Posts
    67

    Re: how do I make fields name with space in between...

    Try this:

    INSERT INTO Test2 ([Chart Number], [Name], [Entry Number])
    SELECT Test.[Chart Number], Test.[Name], Test.[Entry Number]
    FROM Test;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •