Using variables in SQL update

[marcuscoker]

Hi

was wondering if anybody could help me with this

I have the following piece of code

DoCmd.RunSQL "INSERT INTO dbo_TblFileLoaded (PracticeCode, ExtractID) VALUES (sPractice,sExtract)", -1

sPractice,sExtract are variables that i have declared earlier in the code. However, when i run this script it does not put these values into the database. Can anybody help please?

 

[boblarson]

DoCmd.RunSQL "INSERT INTO dbo_TblFileLoaded (PracticeCode, ExtractID) VALUES (" & sPractice & "," & sExtract & ")", -1

 

[marcuscoker]

thanks
for that