How to return query with out headers

D

DG

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
 
J

Joel

See in VBA Help : SQLRequest Function

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

ColNamesLogical must be set to FALSE
 
D

DG

That's great. Thanks


Joel said:
See in VBA Help : SQLRequest Function

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

ColNamesLogical must be set to FALSE
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Returning too many records 4
MS Query problem 2
Excel Error in assignment Excel error 0
Listbox Clears Itself 1
Retrieve Column Header for Specific Data in a Row 3
Strange problem using VB Code in Query 3
Inconsistent results with Query 2
Query Error? (Works in mySQL) 2

Top