Home Forums SQL Server 2005 SQL Server 2005 Strategies Parsing tab selimited text into SQL table RE: Parsing tab selimited text into SQL table
Lisa Cherney
SSC Veteran
Points: 237
More actions
March 14, 2012 at 6:52 am
#1459136
If you need to do this from a .net application, load your data from the file into a DataTable and then use the SQLBulkCopy class (http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx) to move the data to your database.