Having a little trouble with an INSERT statement. I get a runtime error "Missing semicolon(;) at end of SQL statement". This is the INSERT statement:
"INSERT INTO [ExtractDate] ( UniqueID, StartDate ) " & _
"VALUES ( [Unique ID] , Actual_Start )" & _
"FROM [AIS Release and Transport Status]" & _
"WHERE Actual_Start <> 'NA' ; "
Column "Unique ID" is of type number and "Actual_Sta rt is a text field from the "AIS Release and Transport Status" table and the columns being inserted into on the "ExtractDat e" table match the data types. Any help is greatly appreciated.
"INSERT INTO [ExtractDate] ( UniqueID, StartDate ) " & _
"VALUES ( [Unique ID] , Actual_Start )" & _
"FROM [AIS Release and Transport Status]" & _
"WHERE Actual_Start <> 'NA' ; "
Column "Unique ID" is of type number and "Actual_Sta rt is a text field from the "AIS Release and Transport Status" table and the columns being inserted into on the "ExtractDat e" table match the data types. Any help is greatly appreciated.
Comment