I have a simple test table (called test_table) which has two fields: Number and String are the field names.

If I try to use the following SQL command:

INSERT INTO test_table (Number, String) VALUES(13, 'Goodbye')

it fails; I am told that the INSERT INTO syntax is invalid.

If, however, I have a table (simple_table) which has one field: Number and use this SQL command:

INSERT INTO simple_table (Number) VALUES(75)

it works. I have to conclude, therefore, that there is some problem inserting a string, even a short one which is way under the limit for the field (the limit is the default of 50 characters).

I tried (") instead of (') for the string, no change.

I am using an Access (.mdb) database, and using VBScript (although what I am using to do it should be irrelevant!)

Can anyone give me a hint as to what I am doing wrong?

Thanks in advance.