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
