Using SQLBulkOperations in ODBC.jl

[Terry Seaward]

Hi,

How could one use the SQLBulkOperations function in ODBC.jl to insert a DataFrame into a table?

Additional ref: https://msdn.microsoft.com/en-us/library/ms712471(v=vs.85).aspx

- TS

[Jacob Quinn]

As long as your DB table is created correctly (i.e. correct types), you can do

ODBC.load(dsn, "table_name", df)

More docs here: http://juliadb.github.io/ODBC.jl/stable/#ODBC.load-1