tags:

views:

207

answers:

1
+1  Q: 

MS-SQL Bulk Insert w/ RODBC

Is it possible to perform a bulk insert into an MS-SQL Server (2000, 2005, 2008) using the RODBC package?

I know that I can do this using freebcp, but I curious if the RODBC package implements this portion of the Microsoft SQL API and if not, how difficult it would be to implement it.

-- Dan

+1  A: 

You're probably wanting ?sqlSave

Tyler  2009-09-30 17:32:58
Nah, sqlSave will do multiple INSERTS. I want a BULK INSERT which is a single transaction.
ephpostfacto  2009-11-06 21:42:31
does fast=true not do it as a single transaction?
Tyler  2009-11-09 23:40:59

related questions

How can I sort the X axis in a Barplot in R?
Writing a GUI for the BRCAPRO Cancer Gene Risk Calculation Engine
Does R have quote-like operators like Perl's qw()?
csv file with multiple time-series
Resources for learning SAS if you already familiar with R
What's the easiest way to install 100s of files in a Visual Studio setup project
How do i deal with time intervals like 08:00-08:15
Filtering data in R
Converting a localized date of the form 12-okt-2007
R language general question
Vectorize my thinking: Vector Operations in R
Thinking in Vectors with R
What are some good books, web resources, and projects for learning R?
Optimization packages for R
Is there an R package for learning a Dirichlet prior from counts data
WCF Bindings - so many! How do I choose one?
Books for learning the R language
Sample Code for R?
How to test for the EOF flag in R?
How to search for "R" materials?
Explain the quantile() function in R
Worse sin: side effects or passing massive objects?
[R] How to access the last value in a vector?
Understandable documentation about R?
What R package do you use most?