BCP of Fixed Length Fields

[Ben Spigle]

I have a file which is composed of fixed length fields. Each
record is terminated with a carriage return/newline. Does anyone
have an example of a BCP format file I can use to import this
data into SQL Server. I know I have seen this posted before but I
can`t find it in the archives or on MSN...

Thanks!
ben

[yu]

On 9/9/98 3:35:40 PM, Ben Spigle wrote:
> I have a file which is composed of fixed length fields. Each
record is
> terminated with a carriage return/newline. Does anyone
have an example of
> a BCP format file I can use to import this
data into SQL Server. I know I
> have seen this posted before but I
can`t find it in the archives or on
> MSN...

Thanks!
ben
use:
Bcp dbname..table_name in c: empcfg.dat /c /Usa
It works for me.

[VK]

In Books Online find topic called "Using the bcp Format File"(type as is
into search query).
They have a very good example.

VK.