Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    233

    Unanswered: Syntax Error 3134 Insert Statement

    Can anyone tell me what is wrong with the statement.

    SQLText = "INSERT INTO Investor ( InvestorName ) " _
    & "'" & sName & "';"

    I get an syntax error on Insert but i juct cant see what is wrong with this.
    Thanks

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    Sorry mad moment answered my own question.

    SQLText = "INSERT INTO Investor ( InvestorName ) " _
    & "SELECT '" & sName & "';"

Posting Permissions

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