|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to import fixed-width text file in MS SQL 2000?Hello,
Is there a simple answer to this simple question? How to import fixed-width text file? I know the width of the columns but there are so many that I don't want redefine them. I have already a table build for that data with the necessary fields width. In dbase it was such a simple thing to do... Note: I went through the Import wizard in MS SQL 2000 and I could not find any thing there about importing fixed-width text file. Any help is greatly appreciated, Les Already answered in numerous other groups. Please refrain from
multi-posting in the future. Show quote "Tom" <tom@killspam.com> wrote in message news:_0UGd.14493$W33.456187@news20.bellglobal.com... > Hello, > > Is there a simple answer to this simple question? > > How to import fixed-width text file? > > I know the width of the columns but there are so many that I don't want > redefine them. I have already a table build for that data with the necessary > fields width. In dbase it was such a simple thing to do... > > Note: > I went through the Import wizard in MS SQL 2000 and I could not find any > thing there about importing fixed-width text file. > > > Any help is greatly appreciated, > Les > > |
|||||||||||||||||||||||