Exporting Data

[s_wadhwa]

Hi,

I'm trying to write Sql Server view from 3 tables into a query and then
export that data in view to a text file. I want to do the transfer on
click of a button. I'm trying to do it through TransferText but It does
not recognises the view created in the SQL Server.

If any body has any suggestions as to how to Proceed for this kind of
Data Export.

Thanks in advance for your suggestions,
Shalini

 

[bob]

Altho this is not elegant it should work: use the query as the basis for a
make table query. Then export the data in the table.

Bob