On Apr 21, 5:21 pm, Scott David Daniels <scott.dani...@acm.org> wrote: > ericwoodwo...@gmail.com wrote: > > On Apr 21, 4:01 pm, ericwoodwo...@gmail.com wrote: > >> On Apr 21, 3:36 pm, Scott David Daniels <scott.dani...@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...@acm.org
For MS SQL try: BULK INSERT AdventureWorks.Sales.SalesOrderDetail FROM ''<drive>:\<path>\<filename>'' WITH (ROWTERMINATOR = '''+CHAR(10)+''') -- http://mail.python.org/mailman/listinfo/python-list