Re: How to import fixed-width text file in MS SQL 2000?
From: Stuart Fish (stuart_at_fish._no__spam_.net.nz)
Date: 01/17/05
- Next message: AnthonyThomas: "Re: SQL Timeout problem"
- Previous message: JIM.H.: "Q: date comparision"
- In reply to: Tom: "How to import fixed-width text file in MS SQL 2000?"
- Next in thread: Tom: "Re: How to import fixed-width text file in MS SQL 2000?"
- Reply: Tom: "Re: How to import fixed-width text file in MS SQL 2000?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 Jan 2005 08:53:45 +1300
This can be done through the DTS import wizard in Enterprise Manager under
Tools --> Data Transformation Services --> Import Data.
In the wizard select the source Data Source as 'Text File'. The wizard will
guide you through the steps.
Alternative methods to DTS are the bcp utility and the 'BULK INSERT'
command.
-- ---------- Stuart Fish www.technologic.co.nz "Tom" <tom@killspam.com> wrote in message news:M0UGd.14491$W33.456289@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 > >
- Next message: AnthonyThomas: "Re: SQL Timeout problem"
- Previous message: JIM.H.: "Q: date comparision"
- In reply to: Tom: "How to import fixed-width text file in MS SQL 2000?"
- Next in thread: Tom: "Re: How to import fixed-width text file in MS SQL 2000?"
- Reply: Tom: "Re: How to import fixed-width text file in MS SQL 2000?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
