This is a discussion on help me! read text file in sql within the SQL Server forums, part of the Microsoft SQL Server category; --> HELLO, please help me, how to read txt file and then insert it to sql table. i have file ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| HELLO, please help me, how to read txt file and then insert it to sql table. i have file like this name.txe <... 012301231923123902132003 23423i4u23490342342342343 ....> I have 4 column and want to fractionise this text '012301231923123902132003' and put in to table. Best regards Robert |
| |||
| Hi If you want to use DTS see the following tutorial http://www.sqldts.com/default.aspx?6,107,276,7,1 John "Robert K" <rkloma@hotmail.com> wrote in message news:bhap7a$c3n$1@news.onet.pl... > HELLO, > > please help me, how to read txt file and then insert it to sql table. > > i have file like this name.txe > > <... > 012301231923123902132003 > 23423i4u23490342342342343 > ...> > I have 4 column and want to fractionise this text '012301231923123902132003' > and put in to table. > > > > Best regards > > Robert > > |
| Thread Tools | |
| Display Modes | |
|
|