USE pubs
GO

CREATE TABLE invoices (
  rowid INTEGER PRIMARY KEY, 
  invoicedoc XML)
GO

-- the myinvoices.txt fields must be separated by tabs
INSERT invoices
 SELECT *
 FROM  OPENROWSET
  (Bulk 'c:\myinvoices.txt', formatfile = 'c:\bcpformat.xml') AS X
GO

CREATE TABLE invoices2 ( 
  invoicedoc XML)
GO

INSERT invoices2
SELECT *
FROM OPENROWSET
(Bulk 'c:\myinvoices.txt', SINGLE_CLOB) AS X
go