Posted by cbanks on 11/28/05 19:24

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

Thanks
Charles

• Next in forum: multi-field primary key
• Prev in forum: Data grouped by 20 minutes?
• Thread view: Bulk Import with header in text file

[Reply to this message]