Inserting Data into a Memo Type field

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.')
BasicfarmerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
try this, enclose the field "Note" in brackets [Note], Note is one of reserved words in access


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.')
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bill RossProgrammerCommented:
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
0
hnasrCommented:
If previous comments do not resolve the problem, upload a database showing the issue.
0
BasicfarmerAuthor Commented:
Changing the field Note to Notes was the answer...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.