stop returning column headings from DB query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I put together a query to go against Oracle that returns a block of data to
the spreadsheet. Is there an option somewhere to have the "Return Data to
Excel" do so without also returning the column headings? I want the data
only.

thanks - Russ
 
There are 2 places that you can change that setting.....

1)When you return data from MS Query the dialog where you select the
location for the data has a Properties button.
Click that button
UNcheck: Include Field Names.......click [OK]
Continue selecting the query destination

OR
2)After the data has been pulled from Oracle
Right-click in the data table
Select: Data Range Properties
UNcheck: Include Field Names.......click [OK]
Right-click in the data table
Select: Refresh Data

In the first method, no field headings would be returned
In the second method, existing field headings are removed

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Perfect Ron! I was looking all over the place as I felt there must be an
Option or something, but couldn't find it. Thanks very much!

Ron Coderre said:
There are 2 places that you can change that setting.....

1)When you return data from MS Query the dialog where you select the
location for the data has a Properties button.
Click that button
UNcheck: Include Field Names.......click [OK]
Continue selecting the query destination

OR
2)After the data has been pulled from Oracle
Right-click in the data table
Select: Data Range Properties
UNcheck: Include Field Names.......click [OK]
Right-click in the data table
Select: Refresh Data

In the first method, no field headings would be returned
In the second method, existing field headings are removed

Does that help?
***********
Regards,
Ron

XL2002, WinXP


xrbbaker said:
I put together a query to go against Oracle that returns a block of data to
the spreadsheet. Is there an option somewhere to have the "Return Data to
Excel" do so without also returning the column headings? I want the data
only.

thanks - Russ
Click to expand...
Click to expand...
 
I'm so glad that worked for you.....thanks much for the feedback!

***********
Regards,
Ron

XL2002, WinXP


xrbbaker said:
Perfect Ron! I was looking all over the place as I felt there must be an
Option or something, but couldn't find it. Thanks very much!

Ron Coderre said:
There are 2 places that you can change that setting.....

1)When you return data from MS Query the dialog where you select the
location for the data has a Properties button.
Click that button
UNcheck: Include Field Names.......click [OK]
Continue selecting the query destination

OR
2)After the data has been pulled from Oracle
Right-click in the data table
Select: Data Range Properties
UNcheck: Include Field Names.......click [OK]
Right-click in the data table
Select: Refresh Data

In the first method, no field headings would be returned
In the second method, existing field headings are removed

Does that help?
***********
Regards,
Ron

XL2002, WinXP


xrbbaker said:
I put together a query to go against Oracle that returns a block of data to
the spreadsheet. Is there an option somewhere to have the "Return Data to
Excel" do so without also returning the column headings? I want the data
only.

thanks - Russ
Click to expand...
Click to expand...
Click to expand...
 
Back
Top