Unix Technical Forum

help me! read text file in sql

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


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 05:27 PM
Robert K
 
Posts: n/a
Default help me! read text file in sql

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


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 05:27 PM
John Bell
 
Posts: n/a
Default Re: help me! read text file in sql

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



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-28-2008, 05:27 PM
Anith Sen
 
Posts: n/a
Default Re: help me! read text file in sql

See response in microsoft.public.sqlserver.programming

--
- Anith
( Please reply to newsgroups only )


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:19 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com