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!
HELP... ihow to mport .txt files into sql 2005!!
Collapse
X
-
Tags: None
-
Hi there,Originally posted by Erniepiggyhi, 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!
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