Jim: I seem to remember something about Access that necessitates specifying the exact columns you want to insert. It has to do with the fact that Access has some hidden columns that it uses to keep track of rows. I think these are kind of like a computed column so you can't insert data into them anyway.
Maybe that will help. Mike Ramsour AK Steel Coshocton Works Quality Department Phone/VMS: 740-829-4340 -----Original Message----- From: Jim Belisle [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 11:43 AM To: [email protected] Subject: [RBASE-L] - RE: INSERTING INTO ACCESS FROM RBASE I tried that also. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Wednesday, January 09, 2008 10:44 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: INSERTING INTO ACCESS FROM RBASE Jim, (BLQ-TAPE112,BLQ-TAPE3) Shouldn't that be ('BLQ-TAPE112','BLQ-TAPE3')? Claudine :) ________________________________________ 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
