The TargetText object implements the functionality to output data from SQL*XL to a flat file. You may use any
or no field separator. The properties of TargetText determine the way data is output to the plain text file. To
obtain a reference to the TargetText object use the Targets property of the SQLXL
object. Example: SQLXL.Targets( litText ).Headings = False
Physically, output is generated by the Statement objects
notably the StmtDQL object that implements select statements.
The execute method of the Statement outputs the data according to the setting of the Target property on the Statement.
If Statement.Target = litText then output will be generated as a plain text file.
File name for the new text file. (Full path!)
Character or string to separate the database field. Set to "," for a CSV file, set to a vbTab for a tab
delimited file, etc.
Create a CSV output file:
SQLXL.SQL.setText Text := "select * from emp"
Set SQLSL.SQL.Statements(1).Target= Targets(litText )
Targets(litExcel).FileName = "c:\test.csv"
Targets(litExcel).FieldSeparator = ","
Note: Please record all code
through the macro recorder.
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.