I'm trying to insert new row into access table in vb.net.
Following code is giving me Syntax error for 'Insert into' statement. Please help me to solve this.
Dim strJobNo As String
    Dim strpm As String
    Dim strpmcell As String
    Dim strJobName As String
    Dim strSiteStreet As String
    Dim strSiteCity As String
    Dim intState As Integer
    Dim strZip As String
    Dim strGenContr As String
    Dim strGcProjId As String
    Dim strOwner As String
    Dim strStart As Date
    Dim strEnd As Date
    Dim intContWith As Integer
    Dim intContPm As Integer
    Dim strContPO As String
    Dim BasePoAmt As Double
    Dim strContPrjNo As String
    Dim contBillDt As String
    Dim intRetainage As Integer
    Dim strLiquidatedDmg As String
    Dim strWarranty As String
    Dim ocip As String
    Dim bond As String
    Dim eop As String
    Dim CoTotal As Double 'currency
    Dim CtoDt As Double 'currency
    Dim BaseSub As Double 'currency
    Dim intCnctwith As Integer
    Dim strCnctwith As String

myCommand.CommandText = "insert into MasterJobT(job#,jobname,jobstartdate,projectedcomp letiondate,contractpo#,contractproject#,Generalcon tractor,generalcontractorjob#,owner,ourcontractwit h,contractPM,ourprojectmanager,ourpmcellphone,site street,sitecity,sitestate,sitezip,basepoamount,cha ngeordertotal,contracttodate,basesubcontracts,subc ontractcosttodate,retainage,latecharges,warranty,o cip,equalopportunity,bonding,billdate)" _
                                                 & " values('" & strJobNo & "','" & strJobName & "',#" & strStart & "#,#" & strEnd & "#,'" & strContPO & "','" & strContPrjNo & "','" & strGenContr & "','" & strGcProjId & "','" & strOwner & "'," & intContWith & "," & intContPm & ",'" & strpm & "','" & strpmcell & "','" & strSiteStreet & "','" & strSiteCity & "'," & intState & ",'" & strZip & "'," & BasePoAmt & "," & CoTotal & "," & CtoDt & "," _
                                        & BaseSub & "," & SubTotal & "," & intRetainage & ",'" & strLiquidatedDmg & "','" & strWarranty & "','" & ocip & "','" & eop & "','" & bond & "','" & contBillDt & "'"

Can you dump the contents of the CommandText to a label (or somewhere else on the page) and then post the result tot his list?

Maybe one or more values are missing, or your SQL is incorrect, but that's a lot easier to see with the complete SQL.

E.g.:

Label1.Text = myCommand.CommandText

provided you have a label called Label1.

Also, when you post more code in the future, can you please add a line break here and there? The page I typing this reply in, is now about a meter wide which isn't very practical....

Cheers,
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.