SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel Workbooks
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q278973
http://download.microsoft.com/download/excel2000/Sample/12_27_2000/W98NT42KMe/EN-US/Excelado.exe注意这个 SQL:
Select * from [Sheet1$A1:B10]HOWTO: Use ADO with Excel Data from Visual Basic or VBA
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q257819
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q278973
http://download.microsoft.com/download/excel2000/Sample/12_27_2000/W98NT42KMe/EN-US/Excelado.exe注意这个 SQL:
Select * from [Sheet1$A1:B10]HOWTO: Use ADO with Excel Data from Visual Basic or VBA
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q257819
Dim conn As New ADODB.Connection
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Book1.xls;Extended Properties=Excel 8.0;"
conn.Execute "Insert into MyTable (FirstName, LastName)" & _
" values ('Bill', 'Brown')"
conn.Execute "Insert into MyTable (FirstName, LastName)" & _
" values ('Joe', 'Thomas')"
conn.Close