=========
QUESTION
———
How do I add a record to a table using SQL?

 

=========
ANSWER
———
see EXAMPLES

 

=========
EXAMPLES
——— 
SQLTxt = "INSERT INTO 0000T_Log (Dt, Log) VALUES (#" & Now() & "#, '" & Me.CurrentStatus & "')"
CurrentDb.Execute SQLTxt

 

=========
APPLIES TO / KEY WORDS
———
Microsoft Access
SQL
Insert
VBA

 

=========
REF
———
http://www.w3schools.com/sql/sql_insert.asp

 


http://www.anysitesupport.com/sql-insert-statement/
http://anySiteHosting.com