Jim -
FWIW, my connection was an ODBC connection. But at least you got it working! Sami From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Belisle Sent: Thursday, January 10, 2008 1:29 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: INSERTING INTO ACCESS FROM RBASE Thanks to all of you who gave suggestions about inserting into ACCESS from RBASE. Thanks especially to Sami for telling me it did work. That caused me to remember I had just inserted some items into ACCESS, but it was via a DSN less connection. I recreated that type of connection and, eureka!, it worked! I am not sure why the regular ODBC connection does not allow the insert operation. Jim _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sami Aaron Sent: Wednesday, January 09, 2008 10:56 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: INSERTING INTO ACCESS FROM RBASE 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
