Thanks for your reply, but have you tried this yourself?
INSERT INTO MyTable (fld1,fld2,fld03)
But this doesn't:
INSERT INTO MyTable (fld1, fld2, fld3, fld4, fld5)
UNION SELECT '4','5','6'
UNION SELECT '7','8','9'
The error I get is:
Syntax error (missing operator) in query expression...
The problem occurs after the first SELECT. Access seems to be unable to
interprete the rest of the query. Solutions anyone?