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 |
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
 Posted - 2009-02-18 : 13:51:15
|
| Can someone please provide an example using OPENROWSET to read a text file with Fixed width (not csv or tab delimited) fields. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-18 : 13:55:44
|
| http://www.mssqltips.com/tip.asp?tip=1643 |
 |
|
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
Posted - 2009-02-18 : 14:05:13
|
| Thanks Visakh. I have used OPENWORSET before, but only for delimited files. The article does not talk about fixed width files. Can you provide an example of Seleting from a text file with Fixed Width fields? |
|
|
|
|
|
|
OPENROWSET