title: Microsoft VBScript compilation error: Expected end of statement
body: <p>I am trying to insert some records into MS Access Table with the help of below VB Script. But when am trying to execute it, it's throwing Compilation error: Expected end of statement. Could someone please help me figure out where am I going wrong.</p>
  
  <pre><code>Private Sub Form_Click()
  Dim dbs         As DAO.Database
  Dim DbFullNAme  As String
  
  DbFullName = "D:\G\Diamond\FINAL MS-Access\MS-Access project.accdb"
  Set dbs = OpenDatabase(DbFullName)
  
  dbs.Execute "INSERT INTO [2014_Status] ( Prompt, Project_Name, STATUS,Release_Name )SELECT     RoadMap.SPRF_CC, RoadMap.SPRF_Name, RoadMap.Project_Phase,RoadMap.Release_Name FROM RoadMap WHERE (((Exists (select 1 FROM [2014_Status] where RoadMap.SPRF_CC = [2014_Status].[Prompt]))=False));"
  dbs.Close
  End Sub
  </code></pre>