文章: 关于 ADO + Excel + VB 编程!

[Jneu]

http://www.csdn.net/expert/topic/352/352686.shtm

[lgh4073]

在《Excel2000 编程24学时教程》中有比较详细的例题说明，如有需要可来信索取

[Jneu]

SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel Workbooks
http://support.microsoft.com/support/kb/articles/Q278/9/73.ASP
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/support/kb/articles/Q257/8/19.ASP