Professional Web Applications Themes

HELP!! read text file in sql - Microsoft SQL / MS SQL Server

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

  1. #1

    Default HELP!! 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




    Robert Guest

  2. #2

    Default Re: HELP!! read text file in sql

    Try using Bulk Insert and upload the data ... I recommend that you upload
    the same into a temp staging table before uploading into the actual table ..
    A simple example to ilustrate the same :
    http://www.extremeexperts.com/sql/articles/SimpleBulkInsert.aspx

    --
    HTH,
    Vinod Kumar
    MCSE, DBA, MCAD
    www.extremeexperts.com


    "Robert K" <com> wrote in message
    news:bhap5t$c0d$onet.pl... 
    '012301231923123902132003' 


    Vinodk Guest

  3. #3

    Default Re: HELP!! read text file in sql

    Look for the 'BULK INSERT' statement in BOL.

    For example:
    BULK INSERT Northwind.dbo.[Order Details]
    FROM 'f:\orders\lineitem.tbl'
    WITH
    (
    FIELDTERMINATOR = '|',
    ROWTERMINATOR = '|\n'
    )

    HTH


    "Robert K" <com> wrote in message
    news:bhap5t$c0d$onet.pl... 
    '012301231923123902132003' 


    Amy Guest

Similar Threads

  1. read text file insert into database
    By navee in forum Macromedia ColdFusion
    Replies: 2
    Last Post: April 11th, 08:08 AM
  2. read the text file
    By newcf in forum Coldfusion - Getting Started
    Replies: 13
    Last Post: September 2nd, 02:54 PM
  3. Read a text file
    By Mas in forum Macromedia Director Basics
    Replies: 3
    Last Post: September 13th, 08:09 AM
  4. Read in and display a text file?
    By owen in forum ASP Components
    Replies: 5
    Last Post: February 25th, 03:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139