Re: [R] RODBC-Error-sqlSave

2010-05-16 Thread Johan Lassen
Thank you so much for pointing on this obvious check of the MS Access database! Inspired, I tried to import the csv-file directly into the MS Access database and I encountered an Error saying (freely translated from Danish) : "Cannot find search key". The MS Access database is in MS Access-2000 for

Re: [R] RODBC-Error-sqlSave

2010-05-16 Thread Orvalho Augusto
Let us see if it is a R issue. Try this: Read the CSV on Ms Access directly. It is an importation on MsAccess. If you succeed we will check R then. Caveman On Sun, May 16, 2010 at 11:48 AM, Johan Lassen wrote: > Dear R-community, > > After repeating the sqlSave-command 3 times on a dataframe

[R] RODBC-Error-sqlSave

2010-05-16 Thread Johan Lassen
Dear R-community, After repeating the sqlSave-command 3 times on a dataframe (of size 13149 rows * 5 columns) to my MS-Access database I get the following error: *Error in sqlSave(channel, eksport_transp_acc_2, "transp_acc_scenarier", : unable to append to table ‘transp_acc_scenarier’* ** This m