Friday, March 23, 2012

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

No comments:

Post a Comment