Export Query to .txt

[robbydogg]

Hello,

Is it possible to export a query to a text file within the server.

I have a query called Excluded Parts_Repair

and i need it to automatically export the results to a text file on the server called:
J:\Reporting\Weekly\Parts\BI Data Extracts\
as the file name
Excluded_Parts_Repair.txt

is there a macro way of doing this or is it VB all the way?

Thanks
Rob

 

[pbaldy]

Have you looked at TransferText? It is available both in VBA code and as a macro action.

 

[robbydogg]

hi i tried, but got stuck.
i used the parameters:
Transfer Type: Export Delimited
Specification Name: L400 Link Specification (haven't a clue what this is)
Table name: Excluded_Parts_Repair
File Name: J:\GS Reporting\Weekly\Parts\Extracts\Excluded_Parts_Repair.txt
Has Field Names: Yes
HTML Table Name: BLANK
Code Page: 28592: Central European (ISO) (Havent a clue again)


any ideas why it won't work?

Thanks again.

 

[robbydogg]

ah i removed out Specification Name and Code Page and it worked!!!!!!! yay! and thanks for your help anyway.