Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

bulk insert

Status
Not open for further replies.
bmeza

bmeza

MIS
Joined
Dec 2, 2005
Messages
7
Location
MX
Hi, I have a text file and I want to use bulk insert, I now how to do it, but in the text file I have header record and detail record, how can I make a difference to insert in boot tables;the text file can have lot a heaaders and details

example text file
H^MP^319267228^17-FEB-06^^^^GXB
D^GXB10269^US^23^EA^^^^.45632^^MX^^^^
D^GXB10269^US^23^EA^^^^.45632^^MX^^^^
H^MP^319310332^27-FEB-06^^^^GBX
D^GBX10269^US^4^EA^^^^.07936^^MX^^^^
 
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question Question
Cross Join in an Insert Into
Replies
1
Views
587
carp
carp
harfri
  • Locked
  • Question Question
Insert into a new table
Replies
0
Views
440
harfri
harfri
abenitez77
  • Locked
  • Question Question
Insert with Loop
Replies
2
Views
257
abenitez77
abenitez77
skatebkp
  • Locked
  • Question Question
Insert space char into results
Replies
4
Views
528
skatebkp
skatebkp
faimuj
  • Locked
  • Question Question
How to update a field while inserting a row
Replies
3
Views
405
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top