R
R. Weston
Hey, just tested an insert query in Access and this seemd
to work just fine:
INSERT INTO test ( [memo] ) VALUES ("this is a, test");
If you were using a language such as PHP to interface with
the access databse base through ODBC or something, i know
in PHP, you'd have to do something like what you were
thinking for the insert statement to work:
query = "INSERT INTO test ( [memo] ) VALUES (\"this is a,
test\");"
but only for the double quotes do i know that would be a
problem. hope this helps.
to work just fine:
INSERT INTO test ( [memo] ) VALUES ("this is a, test");
If you were using a language such as PHP to interface with
the access databse base through ODBC or something, i know
in PHP, you'd have to do something like what you were
thinking for the insert statement to work:
query = "INSERT INTO test ( [memo] ) VALUES (\"this is a,
test\");"
but only for the double quotes do i know that would be a
problem. hope this helps.