Execute the following Microsoft SQL Server Transact-SQL (T-SQL) script in Management Studio (SSMS) Query Editor, SQLCMD or other client software to a new table. The first line of the data file should be a header:

USE [AdventureWorks]
GO

SELECT *, ColumnZ= convert(char(10),'') INTO dbo.stageInvoice20100901 FROM OPENROWSET('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=e:\data\xml\;Extensions=txt;','SELECT * FROM invdata2.txt')