There is a function explained on MSDN website on this link SAVEASCSV for Query Object.
Syntax of Function :
QueryVariable.SAVEASCSV (FileName[, Format][, FormatArgument])File Name is a text path where query will be Saved.
Format is a option field with 0/1 as parameters
0 means to provide length maually in FormatArgument between any 2 columns
1 means to provide in FormatArgument as , ; or 'tab' for space.
Bug No. 1
'tab' is not working with 1 as paramater it just copies the word tab in between coluum.
Bug No. 2
Microsoft has not written any example with 'tab'
Bug No. 3
Microsoft should notice that 'tab' is working with 0 and not with 1 as FORMAT parameter.
ScreenShot is attached below :-
No comments:
Post a Comment