append error

[slimjen]

all, using 2010. I am trying to run a series of appends but I running into problems. error 3134 syntax error in insert into statement:

sSQL1 = "INSERT INTO tblDemAdv ( ParticipantType, Relationship, ClientID, PolicyHolderID, PolicyHolderSSN, DependentID, DependentSSN " & _
"FirstName, LastName, Address1, Address2, City, State, Zip, Phone, DateofBirth, Age, Disabled, EEType, PlanName, CoverageLevel, " & _
"Carrier, PolicyNumber, PayPeriod, BenID, DedID, Rate,  PerPayPeriod, HisDte ) " & _
"Select tblDemAdv_temp.[Participant Type], tblDemAdv_temp.Relationship, tblDemAdv_temp.[Client ID], " & _
"tblDemAdv_temp.[Policy Holder ID], tblDemAdv_temp.[Policy Holder SSN], tblDemAdv_temp.[Dependent ID], " & _
"tblDemAdv_temp.[Dependent SSN], tblDemAdv_temp.[First Name], tblDemAdv_temp.[Last Name], tblDemAdv_temp.[Address 1], " & _
"tblDemAdv_temp.[Address 2], tblDemAdv_temp.City, tblDemAdv_temp.State, tblDemAdv_temp.Zip, tblDemAdv_temp.Phone, " & _
"tblDemAdv_temp.[Date of Birth], tblDemAdv_temp.Age, tblDemAdv_temp.Disabled, tblDemAdv_temp.[EE Type], " & _
"tblDemAdv_temp.[Plan Name], tblDemAdv_temp.[Coverage Level], tblDemAdv_temp.Carrier, tblDemAdv_temp.[Policy Number], " & _
"tblDemAdv_temp.[Pay Period], tblDemAdv_temp.[Ben ID], tblDemAdv_temp.[Ded ID], tblDemAdv_temp.[ Rate*], " & _
"tblDemAdv_temp.[ Per Pay Period], tblDemAdv_temp.HisDte, " & _
"FROM tblDemAdv_temp;"

It runs from the design view under queries but will not from the form. Can any one spot what's going on? Thanks

[JoeM]

At first glance, it looks like you are missing a comma between the "DependentSSN" and "FirstName" fields (end of your first line, beginning of the second).

Also, do you really have a field name [ Rate*]? Spaces and special characters like asterisks should really be avoided in object and field names.

[orange]

In addition to JoeM's comment, I see an extra comma at

.......
"tblDemAdv_temp.[ Per Pay Period], tblDemAdv_temp.HisDte, " & _ "FROM tblDemAdv_temp;"

Your naming convention with embedded spaces could cause you syntax errors at some point. You'll have to enclose
these names in square brackets -- always.

[slimjen]

Fixed the comma issue. Now getting same error "3134 Syntax error in Insert...."
The select from table is a temp table imported in from an excel spreadsheet. I changed the field names in the perm table. Thanks