HELP... ihow to mport .txt files into sql 2005!!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Erniepiggy
    New Member
    • Nov 2006
    • 1

    HELP... ihow to mport .txt files into sql 2005!!

    hi, i'm juz install sql 2005,i'm running all data with script tat i wrote but problem is how could i import this .txt files into my database (sql 2005)? i'm a new user to using this new version,hope all guys can give a big hands. thanks!
  • sashi
    Recognized Expert Top Contributor
    • Jun 2006
    • 1749

    #2
    Originally posted by Erniepiggy
    hi, i'm juz install sql 2005,i'm running all data with script tat i wrote but problem is how could i import this .txt files into my database (sql 2005)? i'm a new user to using this new version,hope all guys can give a big hands. thanks!
    Hi there,

    Data Transformation Service Tool (DTS) can be very handy, just make sure the .txt file is in comma delimited format. Good luck & Take care.

    Comment

    Working...