Re: Bulk Import with header in text file
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 28 Nov 2005 22:52:35 +0000 (UTC)
(cbanks@xxxxxxxxxxxxxx) writes:
> I would appreciate some help on a procedure that I have. Using Bulk
> Insert, I would like to import records from a text file. The issue I
> have is the file contains a header - '1AMC_TO_Axiz' and a footer
> '1AMC_TO_Axiz2". Using a format file, I can get the import to work by
> editing the file and removing these two entries. Is there a way to
> setup the format file to skip these two entries? My file currently
> looks like this:
> 7.0
> 16
> 1 SQLCHAR 0 50 "|" 1 keyMemberNo
> 2 SQLCHAR 0 10 "|" 2 fldEffdate
> ................
> 16 SQLCHAR 0 10 "\r\n" 16 fldNewRecord
BCP is very squared, and there is no way to specify a footer or a header.
The one exception is when you can hide the header in the format somehow.
If the headers fits into the format, you can the FIRSTROW and LASTROW
options to skip them.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Bulk Import with header in text file
- From: cbanks
- Re: Bulk Import with header in text file
- References:
- Bulk Import with header in text file
- From: cbanks
- Bulk Import with header in text file
- Prev by Date: Re: SQL errors, trapping in Server Agent
- Next by Date: STORED PROCEDURE - passing table name as a parameter
- Previous by thread: Re: Bulk Import with header in text file
- Next by thread: Re: Bulk Import with header in text file
- Index(es):
Relevant Pages
|
