I don't know about SQL Server 2005 but in SQL 2000 you can import data using external BCP utility, T-SQL BULK INSERT statement or DTS.

>
>I'm very new in using SQL server, I have plans to use the free sql server express edition. Thinking in terms of foxpro: it's possible in vfp very simply to import data from a sdf textfile in a predefined table (append from...)
>
>How simple is it to do the same using sql server in general and the express edition in specific?