为什么ado打不开excel......
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim connStr As String
'fbd1.ShowDialog()
'MsgBox(fbd1.SelectedPath)
ofd1.Filter = "Excel文件|*.xls"
ofd1.ShowDialog()
fileNameStr = ofd1.FileName
connStr = $"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={fileNameStr };Extended Properties=Excel 12.0"
conn.Open(connStr)
提示
发生了 System.Runtime.InteropServices.COMException
HResult=0x800A0E7A
Message=未找到提供程序。该程序可能未正确安装。
Source=ADODB.Connection