<div>
Hi,<br />
<br />
Try:<br />
<br />
&quot;INSERT INTO ShipTo (ProjectID,Company,Attenti<wbr />on,Address<wbr />1,City,Sta<wbr />teID,Zip,P<wbr />hone,Email<wbr />,[Note]) VALUES (4,'My Company','Johnny Rocket','2000 My Street','Fort Worth',43,'76001','817-626<wbr />-0987','me<wbr />@gmail.com<wbr />','This is a memo test.');&quot;<br />
<br />
Also verify that the field Note is not named &quot;Notes&quot;<br />
<br />
Regards,<br />
<br />
Bill
</div>


Hi,

Try:

"INSERT INTO ShipTo (ProjectID,Company,Attention,Address1,City,StateID,Zip,Phone,Email,[Note]) VALUES (4,'My Company','Johnny Rocket','2000 My Street','Fort Worth',43,'76001','817-626-0987','me@gmail.com','This is a memo test.');"

Also verify that the field Note is not named "Notes"

Regards,

Bill

<div>
If previous comments do not resolve the problem, upload a database showing the issue.
</div>


If previous comments do not resolve the problem, upload a database showing the issue.

<div>
Changing the field Note to Notes was the answer...
</div>


Changing the field Note to Notes was the answer...

<div>
<div class="content wysiwyg-content">
Hello, i have written and insert statement to insert data into a table. The very last field in the table and in the insert statement is a memo type field. When i run this statement i get a Syntax Error. If i remove the memo field data from the statement it runs just fine and inserts all of the data. What i am missing here? I don't see it. Should i be formatting it differently for the memo field?<br />
<br />
INSERT INTO ShipTo (ProjectID,Company,Attenti<wbr />on,Address<wbr />1,City,Sta<wbr />teID,Zip,P<wbr />hone,Email<wbr />,Note) VALUES (4,'My Company','Johnny Rocket','2000 My Street','Fort Worth',43,'76001','817-626<wbr />-0987','me<wbr />@gmail.com<wbr />','This is a memo test.')
</div>
</div>


Hello, i have written and insert statement to insert data into a table. The very last field in the table and in the insert statement is a memo type field. When i run this statement i get a Syntax Error. If i remove the memo field data from the statement it runs just fine and inserts all of the data. What i am missing here? I don't see it. Should i be formatting it differently for the memo field?

INSERT INTO ShipTo (ProjectID,Company,Attention,Address1,City,StateID,Zip,Phone,Email,Note) VALUES (4,'My Company','Johnny Rocket','2000 My Street','Fort Worth',43,'76001','817-626-0987','me@gmail.com','This is a memo test.')

Inserting Data into a Memo Type field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.