My SQL statement below is giving me a problem:



strSQL = "Insert into members (" & strNames & ") VALUES (" & strValues 

& ") where id =  '" & ProspectID & "'"



The error it is returning:



Insert into members 

(greet,fname,lname,email,phone,city,state,website,industry,stages,interests

,comments,MemberType,DateJoined,ipaddress) VALUES 

('Mr.','Prospect2','asd','ads','ad','sd','sd','sd','sd','Preseed','Business

Modeling','sdsd','Entrepreneur','3/30/01 8:27:46 AM','66.26.88.21') where 

id = '' 



Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 



[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of 

SQL statement.