如果工作表的第一行没有列名称，如何使用ADODB连接从Excel中检索数据？ [英] How to retrieve data from Excel with ADODB connection if the first line of the worksheet does not have the column name?

问题描述

我使用以下类型的代码从一些Excel工作簿中检索数据（路径是一个参数）

I use the following type of code to retrieve data from some Excel Workbooks (path is a Parameter)

Dim strSQL  As String, conStr as String
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset


conStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" & path & "';" & _
             "Extended Properties=""Excel 12.0;HDR=YES;IMEX=1;"";"

strSQL = "SELECT [Field1], [Field2] FROM [Worksheet$] WHERE [Thing1] > 1"

cnn.open conStr   
rs.Open query, cnn, adOpenStatic, adLockOptimistic, adCmdText

如果字段的名称是在工作表的第一行。问题是我需要从工作表中检索数据表从另一行开始的数据（第10行）。

That code works fine if the names of the fields are on the first row of the worksheet. The problem is that I need to retrieve data from a worksheet that the data table begins on another row (Row 10).

有没有办法指定第一行我的数据表？

Is there a way to specify the first row of my data table?

推荐答案

看到这个 Microsoft页面。您可以使用以下内容：

See this Microsoft page. You can use something like:

strSQL = "SELECT [Field1], [Field2] FROM [Worksheet$$A10:B43] WHERE [Thing1] > 1"

这篇关于如果工作表的第一行没有列名称，如何使用ADODB连接从Excel中检索数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！