rsqlserver icon indicating copy to clipboard operation
rsqlserver copied to clipboard

Error in textConnection(message) : invalid 'text' argument

Open datalee opened this issue 7 years ago • 4 comments

when i use the function:dbWriteTable to writetable into sqlserver,there is something wrong with it: 1.write the data less than 999 rows,it's ok,not the error :Error in textConnection(message) : invalid 'text' argument dbWriteTable(conn, 'SIX', data[1001:1999,], row.names = F, append = T)

2.when the data >=1000 rows, the error like this dbWriteTable(conn, 'SIX', data[1:1000,], row.names = F, append = T)

can you help me? what's wrong with it? thks.

datalee avatar Jan 24 '18 02:01 datalee

Did you mean to swap the statement with the error? You have listed (1) as having the error.

Can you provide an example data frame of 1000 rows that is causing this bug? I think it's related to a previous issue that's been fixed.

ruaridhw avatar Jan 24 '18 08:01 ruaridhw

@ruaridhw error_dataframe

datalee avatar Jan 24 '18 09:01 datalee

Please upload it as a text CSV file, not .rar

ruaridhw avatar Jan 24 '18 10:01 ruaridhw

@ruaridhw csv

datalee avatar Jan 25 '18 00:01 datalee