What is wrong with this SQL?

[agehoops]

StrSQL = "INSERT INTO LV (Directory_Name:,Filename:, Total_Files,Total_Records:,Total_Batches:, Total_YH) VALUES ('" & DirectoryName & "', '" & FileName & "', TotalFiles , TotalRecords , TotalBatches , TotalYH);"

Have tried loads of combinations of the " ' and ' " to get it working but just keeps giving me the damn syntax error!!!

What's wrong with it? Thanks

 

[Moniker]

Why are there colons in the field names?! (That's the issue, btw.)

StrSQL = "INSERT INTO LV ([Directory_Name:],[Filename:], Total_Files,[Total_Records:],[Total_Batches:], Total_YH) VALUES ('" & DirectoryName & "', '" & FileName & "', TotalFiles , TotalRecords , TotalBatches , TotalYH);"

 

[agehoops]

Thanks. Works a treat

No Idea why there are Colons. Not my DB. Helping someone out and they've put them in. But i've got it working now with them so all is well. Thanks