Import Blocks of Data in db Fields

• tac71

  SSC Journeyman

  Points: 83

  More actions

  May 2, 2002 at 1:13 pm

  #357528

  I have a text file with multiple blocks of data (like address blocks) separated from each other by a blank line. How can I import each line of each block into a SQL database table that has defined fields?

  Thanks.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 2, 2002 at 3:18 pm

  #428386

  Duplicate post see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3991&FORUM_ID=9&CAT_ID=1&Topic_Title=Import+Blocks+of+Data+into+db+Fields&Forum_Title=General

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)