import file

#1

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.

#2

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 (AT) gmail (DOT) com>
wrote:

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

import file

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

import file - 11-06-2006 , 03:29 PM

Re: import file - 11-08-2006 , 09:19 PM