Very Computer

Is there a fast way to do it without having to write a VB
application going through ADO/ODBC to create that flat file ?
The reason I'm asking is that maybe SQL Server already has
some built-in features to do such a thing without having to
write a VB or VC component to do it.

Note that I'm not asking how to write a VB component to do it
because I know how to do it, I just want to know if there is
a faster, simpler way to do it.

Please reply to my email personally since it's much faster
for me to locate the answer.

Regards.

Lan.

Create a view on the table containing only the 3 fields you need, and the
check out the bcp utility in Books Online. bcp is available in both SQL
Server 6.5 and SQL Server 7.0.

Quote:> Hi
> I need to be able to dump all the records of a SQL Server
> database into a flat text file but I just want to dumb
> certain fields.
> For example, my database contains 10 millions records
> and its structure has 10 fields. I want to dump these 10
> millions records into a flat file but only want to keep
> 3 fields out of 10.

> Is there a fast way to do it without having to write a VB
> application going through ADO/ODBC to create that flat file ?
> The reason I'm asking is that maybe SQL Server already has
> some built-in features to do such a thing without having to
> write a VB or VC component to do it.

> Note that I'm not asking how to write a VB component to do it
> because I know how to do it, I just want to know if there is
> a faster, simpler way to do it.

> Please reply to my email personally since it's much faster
> for me to locate the answer.

> Regards.

> Lan.

Quote:> Hi
> I need to be able to dump all the records of a SQL Server
> database into a flat text file but I just want to dumb
> certain fields.
> For example, my database contains 10 millions records
> and its structure has 10 fields. I want to dump these 10
> millions records into a flat file but only want to keep
> 3 fields out of 10.

> Is there a fast way to do it without having to write a VB
> application going through ADO/ODBC to create that flat file ?
> The reason I'm asking is that maybe SQL Server already has
> some built-in features to do such a thing without having to
> write a VB or VC component to do it.

> Note that I'm not asking how to write a VB component to do it
> because I know how to do it, I just want to know if there is
> a faster, simpler way to do it.

> Please reply to my email personally since it's much faster
> for me to locate the answer.

> Regards.

> Lan.