Hi,
I receive the following error, but struggling to resolve this issue.

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/TheBranch/added.asp, line 97

Line 97 reads: myCon.Execute(mySQL)

Heres the SQL stuff to:
<%
Dim mySQL, myName, mySurname, myAge, myStatus, myEmail, myPword, myPhone
Dim myTown, myCountry, myWork, myDesc
myName = Request.Form("BrfName")
mySurname = Request.Form("BrSurname")
myAge = Request.Form("BrAge")
myStatus = Request.Form("BrStatus")
myEmail = Request.Form("BrEmail")
myPword = Request.Form("BrPword")
myPhone = Request.Form("BrPhone")
myTown = Request.Form("BrTown")
myCountry = Request.Form("BrCountry")
myWork = Request.Form("BrWork")
myDesc = Request.Form("BrDesc")
mySQL = "INSERT INTO tbl_Branch " _
    & "(BrfName, BrSurname, BrAge, BrStatus, BrEmail, BrPword, BrPhone) " _
    & "(BrTown, BrCountry, BrWork, BryDesc) " _
    & "SELECT '" & myName & "' AS BrfName, '" _
    & mySurname & "' AS BrSurname, '" _
    & myAge & "' AS BrAge, '" _
    & myStatus & "' AS BrStatus, '" _
    & myEmail & "' AS BrEmail, '" _
    & myPword & "' AS BrPword, '" _
    & myPhone & "' AS BrPhone, '" _
    & myTown & "' AS BrTown, '" _
    & myCountry & "' AS BrCountry, '" _
    & myWork & "' AS BrWork, '" _
    & myDesc & "' AS BrDesc;"
myCon.Execute(mySQL)
myCon.Close
Set myCon = Nothing
%>
Any help most appreciated. TIA:)

You have several syntax problems.

The format of an insert statement is like this:

INSERT INTO TableName (Column List) VALUES (Value List)

Where:
TableName is the table you are inserting into
Column List is a comma delimited list of the fields you are inserting values into
And Value list is a comma delimited list of the values that are to be inserted into the fields.

So... you have several problems.
I would suggest that you work out your sql insert statement in some database tool (like Access or Slq Server query analyzer) and then make your script create that statement.

For example you have the following bit of code:
That should be like this:
without the extra parenthisis in the middle... and so on.

Woody Z http://www.learntoprogramnow.com

Hi and thanks for the response.
I've managed to get the correct SQL in place and it now works. Thanks!