Reading Ad Hoc Text Files with OpenDataSource

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

A sample schema.ini entry would look like:

[test1.txt]
Format=TABDelimited
ColNameHeader=False
Col1=num1 text
col2=num2 text
col3=num3 text


GO
EXEC sp_configure 'show advanced option', '1';
GO
Reconfigure
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', '1'
GO
Reconfigure


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.