i trying insert record in column named "domain" in ms access db excel using vba. gives error(automation error) same code if change column name domai or do works fine.
the code simple insert statement
code:
'insert tblnm(domain) values('anything')'
reserved words need enclosed in []
insert tblnm([domain]) values('anything') http://www.msoffice.us/access/access20010reserved_words_special_characters.htm
Comments
Post a Comment