syntax error 3134 - Insert into statement

  • Thread starter Thread starter davant
  • Start date Start date
D

davant

This is the code for inserting records from one table to another, I
keep getting the syntax error,#3134, Insert to statement. I can not
figure it out. I have enclosed fields in brackets since I use spaces
in the field names. WHere is my error? I am only filtering the
conferences since it will be listed twice in my source table. Thanks.

davant


Private Sub cmdAppend_Click()

Dim db As Object
Set db = CurrentDb()

DoCmd.SetWarnings False

CurrentDb.Execute "INSERT INTO Conference (Conference ID,Conference
name,start Date,Start time,End time,Length of conference,Conference
Price)Select (DISTINCT [Conference ID],[Conference name],[start
Date],[Start time],[End time],[Length of conference],[Conference
Price]) FROM ExcelDataTable"

DoCmd.SetWarnings True


End Sub
 
I am set; I was missing brackets around the field names;

procedure is working fine.
Debora
 
Back
Top