Linked server

  • Greetings. I was able to add a tab delimited text file as a linked server, basically copying and pasting the BOL example, and changing my file names as follows

    EXEC sp_addlinkedserver txtsrv3, 'Jet 4.0',

    'Microsoft.Jet.OLEDB.4.0',

    'E:\FTTPVA_SHARED\UPLOAD_FORMS\LINK_SRV',

    NULL,

    'Text'

    The problem is that when I select it,

    SELECT *

    FROM txtsrv3...[material_report#txt]

    it is one column, with the column headers connected with underscores. My questions are...

    1) How would I parse a string that has tabs in it? I could easily change it to CSV, but I have too may procedures built around importing tab delimited text files to change them all. Or, how do I get it to display the data in its proper columns?

    2) Where can I see the linked server? EM? I tried a couple of times to get it to work, so I ended up creating a couple that do not work. How can I remove them.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.

  • How can I remove them.

    I found this one...

    sp_dropserver.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.

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

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