Python, MS SQL, and batch inserts

[pruebauno at latinmail.com]

On Apr 21, 5:21 pm, Scott David Daniels <Scott.Dani... at Acm.Org> wrote:
> ericwoodwo... at gmail.com wrote:
> > On Apr 21, 4:01 pm, ericwoodwo... at gmail.com wrote:
> >> On Apr 21, 3:36 pm, Scott David Daniels <Scott.Dani... at Acm.Org> wrote:
> >>> .... I forget the name of the SQL Server bulk loader, ....
>
> bcp (bulk copy) was the name of the bulk loader.  I just remembered.
>
> Sorry, no more exciting advice.  it does sound like a good idea to go
> to a SQL Server group.
>
> --Scott David Daniels
> Scott.Dani... at Acm.Org

For MS SQL try:

BULK INSERT AdventureWorks.Sales.SalesOrderDetail
FROM ''<drive>:\<path>\<filename>''
WITH (ROWTERMINATOR = '''+CHAR(10)+''')