What's wrong with this INSERT statement

adamlam

Please help the master to see what is wrong with the following INSERT statement:

Sql = "Insert into Art_Info (Title, Content, Author, From, KeyWords) values ​​('"&Title. [Text]&".,'"&Content. [Text]&"','"&StrAuthor&"' , '"&StrFrom&"', '"&StrKeyWords&"') "

For illustration, this statement is to save the input information in the web page text in the access database

小老鹰

Sql = "Insert into Art_Info (Title, Content, Author, [From], KeyWords) values ​​('"&Title. [Text]&"', '"&Content. [Text]&"', '"&StrAuthor&"','"&StrFrom&"','"&StrKeyWords&"')"


--From is a reserved word in the system, you need to add []

adamlam

thank. . .
Okay. . .
By the way, apart from FROM being a system reserved word, what else is not. . . . .

adamlam

Look at it, it feels like some complete words

You should write a variable name in the future when you write a shorthand for the data type. You don't have to worry about reserved words. . .

cairui1

Sql = "Insert into Art_Info ([Title], [Content], [Author], [From], [KeyWords]) values ​​('"&Title. [Text]&"', '"&Content. [Text]&"','"&StrAuthor&"','"&StrFrom&"','"&StrKeyWords&"')"