| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to return query with out headers
I am running ODBC queries from Excel to pull data from an SQL2000 server.
In my query editor I have: SELECT OL.Item, OL.Item_Desc, OL.Qty FROM TestDatabase.dbo.OurLib OL ORDER OL.Item It returns the data but has a header from the SELECT statement. Item Item_Desc Qty ABC First Item 2 DEF Second Item 3 Can anyone help? DG |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to return query with out headers
See in VBA Help : SQLRequest Function
SQLRequest(ConnectionStr, QueryText, OutputRef, DriverPrompt, ColNamesLogical) ColNamesLogical must be set to FALSE I am running ODBC queries from Excel to pull data from an SQL2000 server. In my query editor I have: SELECT OL.Item, OL.Item_Desc, OL.Qty FROM TestDatabase.dbo.OurLib OL ORDER OL.Item It returns the data but has a header from the SELECT statement. Item Item_Desc Qty ABC First Item 2 DEF Second Item 3 Can anyone help? DG |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to return query with out headers
That's great. Thanks
"Joel" wrote in message ... See in VBA Help : SQLRequest Function SQLRequest(ConnectionStr, QueryText, OutputRef, DriverPrompt, ColNamesLogical) ColNamesLogical must be set to FALSE I am running ODBC queries from Excel to pull data from an SQL2000 server. In my query editor I have: SELECT OL.Item, OL.Item_Desc, OL.Qty FROM TestDatabase.dbo.OurLib OL ORDER OL.Item It returns the data but has a header from the SELECT statement. Item Item_Desc Qty ABC First Item 2 DEF Second Item 3 Can anyone help? DG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you rename table headers in a query using Offic 07? | Excel Worksheet Functions | |||
| Incomplete query return, who can help? | Excel Programming | |||
| VLOOKUP return query | Excel Discussion (Misc queries) | |||
| Query to Return Value from Seperate Worksheet | Excel Programming | |||
| ODBC query excluding headers | Excel Programming | |||
Hybrid Mode
