Are you referring to the JET engine databse (an MDB file), then Yes, Access SQL supports INSERT.
The syntax in your example is not JET/Access SQL but for MS SQL.
Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com