Home All Groups Group Topic Archive Search About

How to import fixed-width text file in MS SQL 2000?

Author
17 Jan 2005 7:08 PM
Tom
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

Author
17 Jan 2005 8:37 PM
Adam Machanic
Already answered in numerous other groups.  Please refrain from
multi-posting in the future.

--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--


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
>
>

AddThis Social Bookmark Button