how do i import text file with different delimited...HELP

  • I am receiving various types of text file, some pipe delimited, some comma and some TAB. This is what I wrote but it only work for Comma Seperated. How do I specified the type of delimited???

    SELECT *

    FROM OPENROWSET ('MSDASQL',

    'Driver={Microsoft Text Driver (*.txt; *.csv)};HDR=NO;IMEX=1;

    DefaultDir=c:\;

    Extensions=csv;',

    'SELECT * FROM myFile.txt')

    any help will be greatly appreciate it

Viewing 0 posts

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