import file

Hi All,
Is there any way to import a text file into a table in sql server 2005
prefarabley in its gui (MS SQL Server Management Studio)?
Thanks.
In Management Studio, right click on a database and select
Tasks, select Import Data. This will start up the SQL Server
Import and Export Wizard. For the Data Source, select the
Flat File Source and walk through the wizard from there.
-Sue
On 6 Nov 2006 13:29:00 -0800, "sara" <sarasara82@.gmail.com>
wrote:

>Hi All,
>Is there any way to import a text file into a table in sql server 2005
>prefarabley in its gui (MS SQL Server Management Studio)?
>Thanks.
sql

Import / Export Data - GUI

Hi,

I am trying Express Edition 2005 but could not found GUI init, can someone advsie that which SQL Server 2005 provides GUI and which one is more friendly to import/export data- thanks

AA

SQL Server Express does not install a GUI client tool. To obtain SQL Server Management Studio Express (SSMSE), download from here:

SQL Server 2005 Express Edition Client Tools
http://tinyurl.com/yelwr9 (SSMSE)

SQL Server 2005 SSMS Express Tutorial
http://tinyurl.com/nqsca

There is NOT a GUI for data import/export included with SQL Express. However, you can use the DTSWizard for some operations. Using Explorer, search for DTSWizard.exe. Most likely located in {InstallLocation}\Microsoft SQL Server\90\DTS\Binn