Jim -
Can you manually insert a new row into the Access table from either a form or the Database Browser? Sami From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Belisle Sent: Wednesday, January 09, 2008 10:27 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: INSERTING INTO ACCESS FROM RBASE Buddy, I just did that while I was waiting for an answer and got the same error. Jim _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Buddy Sent: Wednesday, January 09, 2008 10:27 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: INSERTING INTO ACCESS FROM RBASE 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
