MSDASQL 64位元 32位元 使用

I couldn't get the MSDASQL drivers to work, but got a result with the ACE drivers (NOTE I am on 64-bit so using the ACE drivers). It might be that I need the 64 bit version of MSDASQL..... < http://blogs.msdn.com/b/sqlforum/archive/2010/12/20/faq-why-cannot-64-bit-msdasql-access-a-csv-text-file.aspx

SELECT * 
FROM OPENROWSET (
    'Microsoft.ACE.OLEDB.12.0', 
    'Text;Database=C:\LogReader\AccurateLogReader; ', 
    'SELECT * from Feeders.txt')

If you are on 32-bit, maybe try

SELECT * 
FROM OPENROWSET (
    'Microsoft.Jet.OLEDB.4.0', 
    'Text;Database=C:\LogReader\AccurateLogReader; ', 
    'SELECT * from Feeders.txt')