search

agstudy / rsqlserver

Sql Server driver database interface (DBI) driver for R. This is a DBI-compliant Sql Server driver based on the System.Data.SqlClient.
82 stars 30 forks source link

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

Open datalee opened 6 years ago

datalee commented 6 years ago

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.

ruaridhw commented 6 years ago

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.

datalee commented 6 years ago

@ruaridhw error_dataframe

ruaridhw commented 6 years ago

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

datalee commented 6 years ago

@ruaridhw csv