database field name

Results 1 to 3 of 3

Thread: database field name

  1. #1
    kevin Guest

    Default database field name

    Hi i an inserting some data into a lecacy access table.... but i get an error when i try to Insert into a field wher its name has a white space.<BR><BR>The field name is "Customer Contact". <BR>I wish i could simple chane its name to CustomeContact but my boss will not allow it.<BR><BR>is there any way i can get my insert statement to allow this white space?<BR><BR>strSQl = "insert into TABLE (Customer Contact) values (&#039;"& value &"&#039;);"

  2. #2
    Join Date
    Dec 1969

    Default [table name]

    use square brackets around it<BR>"INSERT INTO [Customer Contact]....

  3. #3
    kevin Guest

    Default RE: [table name]

    Cheers Dom....worked a dream

Posting Permissions

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