Post reply

How to join a Table in SQL Server with a Flat (txt) file?

  • July 26, 2007 at 3:08 am

    #174649

    Hi All!

    I am in trouble... I need to join a Table in SQL Server with Flat/Text File. Flat File and Table both have the same no. of fileds and should be joined with Field ID.

    Can any one tell me how to achieve this task

    Thanks in advance.

    H@ri.

    Cheers,
    Hari
    Tips & Tricks for SQL BI Developers

  • July 26, 2007 at 4:10 am

    #722514

    Check out OPENROWSET in BOL.

  • July 26, 2007 at 4:14 am

    #722515

    There are various things you can do here.  Import the file into a table and then do the join, use openrowset or opendatasource.  Here are a couple of examples.....

    SELECT * FROM OPENROWSET(BULK N'C:\MyFlatFile.txt', FORMATFILE = 'format_file_path' ) AS MyFlatFile

     

    BULK

    INSERT #MyFlatFile

    FROM 'D:\MyFlatFile.txt'

    WITH

    (

    FIELDTERMINATOR

    ='\t',

    ROWTERMINATOR

    = '\n',

    FIRSTROW

    = 2

    )

    Karl
    source control for SQL Server

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply