export

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  March 1, 2011 at 7:10 am

  #145090

  Is it possible to export only 100 records from a text file which has millions of records, if so how?

  I tried from import/export wizard but i could not able to select top 100.

• SkyBVI

  SSCoach

  Points: 15128

  More actions

  March 1, 2011 at 7:54 am

  #1292938

  You can put all the records in the sql server table first, and then select your top 100 or watever resultset you require.

  Regards,

  Sushant

  Regards
  Sushant Kumar
  MCTS,MCP