INSERT SELECT . does work - I just tried it.
Jim - check your rights in the Access database - can you insert a row from within Access? Sami From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Wednesday, January 09, 2008 10:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: INSERTING INTO ACCESS FROM RBASE It's possible that R:Base will not allow the INSERT SELECT syntax across different database types. You may need to DECLARE CURSOR and then create statements of the form INSERT VALUES for each record you want to insert. -- Larry
