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 Mike Lewis 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
Dec 2, 2005
7
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
Cross Join in an Insert Into
Replies
1
Views
157
carp
carp
harfri
  • Locked
  • Question
Insert into a new table
Replies
0
Views
101
harfri
harfri
abenitez77
  • Locked
  • Question
Insert with Loop
Replies
2
Views
49
abenitez77
abenitez77
skatebkp
  • Locked
  • Question
Insert space char into results 1
Replies
4
Views
112
skatebkp
skatebkp
faimuj
  • Locked
  • Question
How to update a field while inserting a row
Replies
3
Views
96
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top