How to return query with out headers

DG · Sep 17, 2008

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.db

urLib 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

Joel · Sep 17, 2008

See in VBA Help : SQLRequest Function

SQLRequest(ConnectionStr, QueryText, OutputRef, DriverPrompt, ColNamesLogical)

ColNamesLogical must be set to FALSE

DG · Sep 17, 2008

That's great. Thanks

Joel said:
See in VBA Help : SQLRequest Function

SQLRequest(ConnectionStr, QueryText, OutputRef, DriverPrompt,
ColNamesLogical)

ColNamesLogical must be set to FALSE