Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AKP2008
Starting Member
45 Posts |
 Posted - 2009-03-03 : 00:35:12
|
| Hi All,I have one requirement. My text file format is like this 05322672910514155511571007533732 WENDY GOXMAN 3300 SHELBY DR I have to import this data into my database using bcp. From 1-7 characters i have to insert into col1 and from 8-9 insert into col2 like this i have to insert into table.How can i specify the positions using command prompt.Please help me.Thanks in Advance. |
|
|
|
|
|
bcp utility