Hi,

I am using the following query retrieve the data from a flat text file. The text is tab delimited.
The same content is also available in a table.

Now I am writing content in to a file in local disk and accessing , instead of doing this can I directly use the output of another query which gives me the same content what is there in the local file.

SELECT * FROM
OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source="D:\TestingFile";Extended properties=Text')...RespnsePract#txt


Is there any other way to achieve the above

Thanks

you can easily use OpenDataSource to get a query from the same instance of SQL Server that you are executing the OpenDataSource from, but I can't think why you'd want to, as there is no information that you couldn't get from a direct Select statement..