importing datas into MS SQL serveur

hello !

I am a student in a compagny because its my training. But, I must use MS SQL server and i dont know at all this software !
I must import datas , which are in a ascii form, into MS SQL serveur 7,0.

Can you give me further information please, because its not easy at all !
thanksYou can use DTS wizard to import data from a text file or other heterogenous data sources.

Refer to books online and the following articles about DTS:
http://www.databasejournal.com/features/mssql/article.php/3325731
http://www.devasp.net/net/search/redirect.asp?sid=927
http://www.devasp.net/net/search/redirect.asp?sid=2671
http://www.sqldts.com

Importing Access database into SQLExpress

I am trying to complete a lab in the Microsoft self-paced training kit, Developing Web Applications with Microsoft Visual C# .NET.

They have provided an Access database named Contacts.mdb and a batch file named InstContacts.bat that uses InstContacts.sql to import the data.

I have installed SQLExpress, but when I run the batch file I get the following:

C:\Microsoft Press\...\data>rem The following command line installs the Contact SQL database

C:\Microsoft Press\...\data>osql -i InstContacts.Sql -E
[SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].
[SQL Native Client]Login timeout expired
[SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

Nevermind, I found the answer here.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=421593&SiteID=1