昨夜小楼zh-CNTue, 08 Jul 2008 00:08:00 GMT60Limpirehttp://blog.csdn.net/Limpire/archive/2008/07/07/2623016.aspxMon, 07 Jul 2008 23:00:00 GMThttp://blog.csdn.net/Limpire/archive/2008/07/07/2623016.aspxcomments/2623016.aspxhttp://blog.csdn.net/Limpire/archive/2008/07/07/2623016.aspx#Feedback0comments/commentRss/2623016.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2623016根据提问者的原始测试数据，生成测试数据表。<img src ="aggbug/2623016.aspx" width = "1" height = "1" />Limpirehttp://blog.csdn.net/Limpire/archive/2008/06/30/2599760.aspxMon, 30 Jun 2008 22:29:00 GMThttp://blog.csdn.net/Limpire/archive/2008/06/30/2599760.aspxcomments/2599760.aspxhttp://blog.csdn.net/Limpire/archive/2008/06/30/2599760.aspx#Feedback0comments/commentRss/2599760.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2599760介绍最新的接口Microsoft.ACE.OLEDB.12.0，可以访问Excel 97-2003和Excel 2007。比较Microsoft.Jet.OLEDB.4.0，着重分析数据类型解析的过程，这是解决NULL值问题的根本。OpenRowSet和OpenDataSource的列顺问题值得关注，容易产生隐藏错误。最后是隐藏Sheet和非常规命名Sheet的访问。<img src ="aggbug/2599760.aspx" width = "1" height = "1" />