How to import from text file

Hi. Basic question: how do you import from a .csv file into a database table? Thank you.

See SQL Server 2000, 2005 Books Online topic:
bcp Utility

or check out DTS/SSIS import tasks

|||You can also use bulk insert.|||

DTS is best to go when you are not sure about few things that are new to you.

http://www.microsoft.com/technet/prodtechnol/speech/library/loganalysis/log_files_UsingDTS.mspx

KBA http://support.microsoft.com/kb/285829