Importing fixed width text files

• sod79

  Newbie

  Points: 9

  More actions

  March 5, 2009 at 10:12 am

  #201987

  What's the best way to import data from a fixed width text file into SQL Server 2005 MSDE edition? The text file in question contains about 2.5 million records and does not have any header information contained within it.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 740109

  More actions

  March 5, 2009 at 10:29 am

  #954192

  I'd say BCP. use a format file.

  http://msdn.microsoft.com/en-us/library/aa174646(SQL.80).aspx