What is wrong with this SQL?

agehoops

Registered User.
Local time
Today, 16:40
Joined
Feb 11, 2006
Messages
351
Code:
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!!! :mad:

What's wrong with it? Thanks
 
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);"
 
Last edited:
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
 

Users who are viewing this thread

Back
Top Bottom