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