Run Time Error 3352 - No destination field name in INSERT INTO statement (Now())

[stildawn]

Hi All

I am getting this error in one of my VBA SQL codes:

Run Time Error 3352 - No destination field name in INSERT INTO statement (Now())

It occurs on this line:

CurrentDb.Execute "INSERT INTO FRT_Additionals_Table SELECT FRT_Additionals_Import_Table.Carrier, FRT_Additionals_Import_Table.[20GP BAF], FRT_Additionals_Import_Table.[40GP BAF], FRT_Additionals_Import_Table.[40HC BAF], FRT_Additionals_Import_Table.[20GP GRI], FRT_Additionals_Import_Table.[40GP GRI], FRT_Additionals_Import_Table.[40HC GRI], FRT_Additionals_Import_Table.[20GP PSS], FRT_Additionals_Import_Table.[40GP PSS], FRT_Additionals_Import_Table.[40HC PSS], FRT_Additionals_Import_Table.[20GP MISC], FRT_Additionals_Import_Table.[40GP MISC], FRT_Additionals_Import_Table.[40HC MISC], FRT_Additionals_Import_Table.[Valid From], FRT_Additionals_Import_Table.[Valid To], FRT_Additionals_Import_Table.Notes, Now() FROM FRT_Additionals_Import_Table;", dbFailOnError + dbSeeChanges

Here is the line again with line breaks for easier reading:

CurrentDb.Execute 
"INSERT INTO FRT_Additionals_Table 
SELECT FRT_Additionals_Import_Table.Carrier, 
FRT_Additionals_Import_Table.[20GP BAF], 
FRT_Additionals_Import_Table.[40GP BAF], 
FRT_Additionals_Import_Table.[40HC BAF], 
FRT_Additionals_Import_Table.[20GP GRI], 
FRT_Additionals_Import_Table.[40GP GRI], 
FRT_Additionals_Import_Table.[40HC GRI], 
FRT_Additionals_Import_Table.[20GP PSS], 
FRT_Additionals_Import_Table.[40GP PSS], 
FRT_Additionals_Import_Table.[40HC PSS], 
FRT_Additionals_Import_Table.[20GP MISC], 
FRT_Additionals_Import_Table.[40GP MISC], 
FRT_Additionals_Import_Table.[40HC MISC], 
FRT_Additionals_Import_Table.[Valid From], 
FRT_Additionals_Import_Table.[Valid To], 
FRT_Additionals_Import_Table.Notes, 
Now() 
FROM FRT_Additionals_Import_Table;", dbFailOnError + dbSeeChanges

The Now() is a timestamp for when this code runs, it goes into the "Lastmodified" field in FRT_Additionals_Table.

As far as I can tell it should work and line up, pics below of both tables structure:



Any help would be greatly appreciated.

[Micron]

It's kind of right there in the message. You haven't identified any fields that will receive the data, and the number of target fields has to be the same as the number of source fields. If this is not a make table query (i.e Select Into...) then see

https://docs.microsoft.com/en-us/off...oft-access-sql

When I have many repeats of a long table name I always use table alias name.

Select T1.this, T1.that, etc. FROM tblWithAVeryLongNameThatIProbablyShouldHaveavoidedInTheFirstPlace AS T1...

[davegri]

Only change necessary, I think, next to last line:

Now() as LastModified

[stildawn]

It's kind of right there in the message. You haven't identified any fields that will receive the data, and the number of target fields has to be the same as the number of source fields. If this is not a make table query (i.e Select Into...) then see

https://docs.microsoft.com/en-us/off...oft-access-sql

When I have many repeats of a long table name I always use table alias name.

Select T1.this, T1.that, etc. FROM tblWithAVeryLongNameThatIProbablyShouldHaveavoidedInTheFirstPlace AS T1...

Ah I see what happened

Only change necessary, I think, next to last line:

Now() as LastModified

Yep that is all that was needed, thanks