Need Query without Field names retriving in MDB?

I am using the MDB as backend, frontend using vb. When i am retriving the output in excel the result provide the output the result with field names. I only need the result, how can i avoid the field name display for that. I am new in this MDB and vb. Please help me for a query providing the result开发者_运维百科 without field names.

Change connection string to exclude headers, as in HDR=No.

Connection strings for Excel at http://www.connectionstrings.com/excel

To retrieve only the data - no headers - simply use the GetString method of your ADODB.Recordset.... I assume you are using ADO....