文章分类 -  VB+Excel开发收集

摘要：转自：http://newkedison.blog.163.com/blog/static/36982258200792892433822/今天研究了一下很久以前就看到的vb把Excel写入Access和Access写入Excel的函数。先看这两个函数（原来有些错误，我改掉了，还有记得要引用“Microsoft DAO 3.6 Object Library”）：Private Sub XlsToMdb(sExcelPath As String, sAccessDBPath As String, sSheetName As String, sAccessTable As String) ' 阅读全文