Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Posts
    22

    Unanswered: How do we migrate data from a csv file in notepad ?

    How do we migrate data from a csv file in notepad ?

    to our MS SQL 2005 Express editioN ?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    SQL Server Integration Services packages can easily import CSV files.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    You could also look at the BCP utility (see books online for more info)
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •