Include the field name

Hi.

I was looking at the table2text utility and was curious if there was any flag that could be set to include the field/column name? The order is different from what I've seen with Excel using ODBC and several tables have very similar data in each column, so I don't want to guess.

Thank you
 

Hi Neil

I assume that you want to use SQL statement as data source, this option is not supported by table2text.As alternative you can use AETL export data action.

www.etl-tools.com/wiki/advanced-etl-proc.../sql-to-text-action/

It does support sql as data source.

No, sorry for the confusion, I'm using an ODBC connection to a local database, and table2text seems to do just fine getting all the records out as a CSV, but the first line of the file doesn't have the column names, so I don't know what data is in which column.

I was hoping something like COLUMN_NAME=TRUE would include the names on the first row.

Does that make sense?

I see what you mean now.You can use FIELDS option for thattable2text.exe DSN=odbcdsn;DISABLEBULKFETCH=TRUE;FIELDS;USER=username;PASSWORD=password;TABLE=table_name;FILE=c:\test.csv;QUOTE=";DELIMITER=,