开发者

Need Query without Field names retriving in MDB?

开发者 https://www.devze.com 2023-01-02 04:43 出处:网络
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 nam

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

0

精彩评论

暂无评论...
验证码 换一张
取 消