What is wrong with this SQL

[PerryG]

It keeps throwing a run-time error 3141

DoCmd.RunSQL "INSERT INTO Resent_FileExtracts ( SUPPLIER, PART_NUMBER, AFN, DATE ) SELECT [" & strFullName & "].Company, [" & strFullName & "].[Part Number], """ & strAFN & """, """ & strDate & """ FROM [" & strFullName & "];"

The part that's torching my ulcer is that it ran two days ago just fine using exactly the same tables.

Thanks one and all.

PerryG

 

[PerryG]

my bad.....runtime error 3134

Thanks.

PerryG

 

[PerryG]

....even worse.....I was using a reserved word as a field name.....do I hear laughter?....it's ok....it's deserved.

Thanks for the interest.

PerryG