Jim I believe you need to add the list of columns you want to insert into.
INSERT INTO TblPartInfo (col1,col2,col3,etc) SELECT col1,col2,col3,etc FROM ........ Buddy ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Belisle Sent: Wednesday, January 09, 2008 11:00 AM To: RBASE-L Mailing List Subject: [RBASE-L] - INSERTING INTO ACCESS FROM RBASE I am attached to an ACCESS database from RBASE. I want to insert specific rows into an ACCESS table. Both tables in both databases have the same columns & types. I am using the normal INSERT command to attempt this. I am getting the error Missing operator in query expression '*********************' Below is the command I am using. INSERT INTO TBLPARTINFO SELECT ALL FROM PARTINFO WHERE PARTNUM IN (BLQ-TAPE112,BLQ-TAPE3) ORDER BY PARTNUM I also tried creating a temporary table with the exact column widths as the ACCESS table and using the above command with the same results. Jim
