Toad World® Forums

Query result is not export to Excel when running automation script

The query is as the following:

SELECT TABLE_NAME,COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ‘Customer’
order by COLUMN_NAME

The expect result should be as the following in result excel file

TABLE_NAME COLUMN_NAME
Customer CustomerAccountID
Customer CustomerAdhocEmail
Customer CustomerBusinessEmail
Customer CustomerBusinessNumber

The actual result is as the following:

TABLE_NAME COLUMN_NAME

Steps to re-create:

  1. Select the query
  2. Select export excel file
  3. Uncheck “overwrite” check box
  4. Open “Advanced Properties” window and then check "Use column name for a header row
  5. Run the automation scripts

Query result is not export to Excel when running automation script

Is this Toad for Oracle that you are talking about? The options and features that you mention are similar to what we have in Toad for Oracle, but a little bit different…which makes me think you have Toad for SQL Server or something else.

If you are using Toad for Oracle, please post a screen shot or two so I can be more clear about what you are doing. If you are using Toad for , well, you’re in the wrong forum, so I can’t help you.

good info