Sami,
When I am in the ACCESS database, I can insert, delete, etc. I do it all the time by copying and pasting from EXCEL workbooks. I will have to do more testing when I return this afternoon. I am using ODBC connections now. I may have to try a DSN less connection. 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
