Reading Ad Hoc Text Files with OpenDataSource (SQL Server Central)

Reading Ad Hoc Text Files with OpenDataSource (SQL Server Central)

select * fromOpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source = C:\; Extended Properties = "Text;HDR=NO;"')...test1#txt

Further Reading:
http://msdn2.microsoft.com/en-us/library/aa276845(SQL.80).aspx - The MSDN general OpenDataSource reference page.
http://msdn2.microsoft.com/en-us/library/ms709353.aspx - The MSDN reference on the schema.ini file.