Correct VBA / SQL statement please
Posted on 2012-04-04
super quick one. I don't know how to use the update statement in sql
This is the essence of what I want:
strSql = "UPDATE " & SettingsTable & "SET [LastOOSLAImportDate] = (#" & Format(Date, "yyyy-mm-dd") & "#)"
SettingsTable is a variable I've defined. LastOOSLAImportDate is a field in the SettingsTable. The table doesn't have a bunch or rows, it's a simple non-indexed table with a few settings on it I use to retrieve settings from.
I want to update the one row thats in there to set LastOOSLAImportDate to today.