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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to import a txt file based on position

Status
Not open for further replies.
kat50

kat50

Technical User
Aug 4, 2009
6
US
How can I import a flat text file into a sql table SQL based on position? As an example
Field Name Start Width Positions
Column 1 1 6 1-6
Column 2 7 9 7-15
Column 3 16 9 16-24
Column 4 25 9 25-33
Ignore
Column 5 33 4932 33-5286
 
Status
Not open for further replies.

Similar threads

jeffwest21
  • Locked
  • Question
BCP Out file with double quotes
Replies
1
Views
676
gk53
gk53
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
840
markjoseph1232
markjoseph1232
Rene1024
  • Locked
  • Question
Help with a Bulk insert statement
Replies
1
Views
533
drlex
drlex
mutley1
  • Locked
  • Question
XLSX import to DTS (SQL 2000)
Replies
0
Views
272
mutley1
mutley1
ciarra41
  • Locked
  • Question
Rollup to one record with same order number
Replies
2
Views
549
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top