Cannot append to table

[Jason]

I have: INSERT INTO Temp_Tbl Br, ONo, SCode, TR SELECT Or.Br, Or.ONo,
Or.SCode, Or.TR From OL WHERE OL.Br = """ & Br & """ AND OL.ONo = " & ONo

The only other way which is much slower is:
set rstfrom = recordset
set rstto = recordset
while not eof
wend

Thanks,
J

 

[Jeff Boyce]

Jason

Not sure I have enough information.

What happens when you try these? Do you get error messages? If so, what do
they say?

More specific descriptions may lead to more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jason]

I haven't tried the rst - all the others I have used work - doing an append
this way would be slower? It's the currentdb.execute command (sorry left
that bit out and the error):
Run-time error '3134':
Syntax error in INSERT INTO statement.

 

[Jason]

Turns out I deleted all the () - Access adds them unneccassarily - but in
this instance the brackets are required around the target field names.