excel中无标题列(即全部为数据时)如下,如有标题列,标题列名称<>NULL dataset应该是vb.net的东西,不过出库方法是一样的。Private Sub Command1_Click() Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset cn.CursorLocation = adUseClient cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1\123.xls;Extended Properties='Excel 8.0;HDR=no;IMEX=1'" Set rs = cn.Execute("Select * From [Sheet1$] where f1<>NULL") Set DataGrid1.DataSource = rs
dataset应该是vb.net的东西,不过出库方法是一样的。Private Sub Command1_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.CursorLocation = adUseClient
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1\123.xls;Extended Properties='Excel 8.0;HDR=no;IMEX=1'"
Set rs = cn.Execute("Select * From [Sheet1$] where f1<>NULL")
Set DataGrid1.DataSource = rs
End Sub
Select * From [Sheet1$] where f1<>NULL
如果是判断第四行是否为空怎么写where后面的
f4<>NULLf1 f2 f3 ...fN你有多少列N