Hi all, Im trying to insert some data into the Access Database.
Is there any problem with the syntax for the codes below?
conn.Execute "insert into Expense(date,title,po_number,po_amount,vendor,acct_code,date_paid,remarks,emp_id) values (" _
& "'" & Request.Form("dateToday") & "', " _
& "'" & Request.Form("title") & "', " _
& "'" & Request.Form("po_number") & "', " _
& "'" & Request.Form("po_amount") & "', " _
& "'" & Request.Form("vendor") & "', " _
& "'" & Request.Form("acct_code") & "', " _
& "'" & Request.Form("remarks") & "', " _
& "'" & Request.Form("date_paid") & "', " _
& "'" & Request.Form("emp_id") & "')"
why do this always occur whenever i activate the form in my asp:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Please help if you can.. any help will be appreciated.
Is there any problem with the syntax for the codes below?
conn.Execute "insert into Expense(date,title,po_number,po_amount,vendor,acct_code,date_paid,remarks,emp_id) values (" _
& "'" & Request.Form("dateToday") & "', " _
& "'" & Request.Form("title") & "', " _
& "'" & Request.Form("po_number") & "', " _
& "'" & Request.Form("po_amount") & "', " _
& "'" & Request.Form("vendor") & "', " _
& "'" & Request.Form("acct_code") & "', " _
& "'" & Request.Form("remarks") & "', " _
& "'" & Request.Form("date_paid") & "', " _
& "'" & Request.Form("emp_id") & "')"
why do this always occur whenever i activate the form in my asp:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Please help if you can.. any help will be appreciated.

Comment