Does anyone know if there is a special syntax needed in SQL for putting data into an access memo field via an SQL statement?

this is what i am doing...

dbValues="#" & savDate & "#" & ",'" & savTitle & "','" & savHide & "','" & savMemo & "'"

queryString="INSERT INTO myfile (kk_Date,kk_Title,kk_Hide,kk_Memo) values (" & dbValues & ")"

getting this error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

Help please!

Nothing special is required. I would suspect that the contents of savMemo has an apostrophe in it somewhere. Look at the value of queryString and see if the SQL statement looks right.

Also make sure your datatypes in access are what you expect. Are you sure kk_date is a date/time? I'd check them all.

Hal Levy
Daddyshome, LLC

This is my question too. And yes there is apostrophies in the data I need to insert, because I'm inserting a blob of html code into this field. I dont have the ability to change these characters then recode the data on the other side because I'm inserting the data into a database that another program utilizes(more or less writing an addon for the program). How can I work around getting the apostrophies into the field? Do I need to use another method of inserting? And if so where should I start lookin?

ok never mind, I figured it out. Since I'd already edited all the quotes out and replaced them with apostrophies, all I had to do was

VALUES(" & Chr(34) & newdesc & Chr(34) & ")

as chr(34) puts the quotes in the sql statement at runtime. If I needed to put quotes in my blob of html I'd still be pretty skrewed, but for now this works fine.