Bulkload option exporting data from R to Teradata using RODBC -

i have done many researches on how upload huge data in .txt through r teradata db. tried use rodbc's sqlsave() did not work. followed other similar questions posted such as: write r teradata in 3.0 or export data frame sql server using rodbc package or how export data r sql server.

however, since teradata somehow structured differently ms sql server, of options suggested not applicable situation. know there teradatar package available has not been updated since 2-3 years ago.

so here 2 main problems facing: 1. how bulk load (all records @ once) data in .txt format teradata using r if there way. (so far tried using sas so, need explore in r) 2. data big 500+ mb cannot load through r, sure there way go around directly pull data server.

here tried according 1 of posts ms sql server:

tosql = data.frame(...) #this doesn't work me cause big. write.table(tosql,"c:\\export\\filename.txt",quote=false,sep=",",row.names=false,col.names=false,append=false);      sqlquery(channel,"bulk                 insert yada.dbo.yada                 '\\\\<server-that-sql-server-can-see>\\export\\filename.txt'                                 (                 fieldterminator = ',',                 rowterminator = '\\n'                 )"); 

*note: there option in teradata insert/import data same writing millions of rows of insert statements.

sorry not have sample codes @ point since package found wasn't right 1 should use.

anyone has similar issues/problems this?

thank in advance!