ADO

以G列分成多个工作表(以宏运行VBA) (Sub aa() Dim a As Integer, b As Integer, c As Integer, sh As Worksheet For a = 2 To [g65536].End(3).Row If Cells(a, 7) <> Cells(a- 1, 7) Then b = a End If c = Range("g:g").Find(Cells(a, 7), , , , , xlPrevious).Row Set sh = Sheets.Add(, Sheets(Sheets.Count)) sh.Name = Sheets("sheet1").Cells(a, 7).Value With Sheets("Sheet1") Sheets("Sheet1").Range(.Cells(b, 1), .Cells(c, 10)).Copy Destination:=sh.[a2] Sheets("Sheet1").Range("a1:j1").Copy Destination:=sh.[a1] a = c End With Sheets("Sheet1").Select Next End Sub )

MiniSQL的大致架构在里面了，可以自己填写里面的模块。。(MiniSQL the general framework in which, you can fill out inside the module. .)

能够连接access 数据库和C++原代码,使用ado方式(Able to connect access database and C++ original code)

A very simple VB Source that can read / write from access database to Grid

说明：  DAO读写(literacy DAO)

说明：  VC操作ADO和datagrid控件的源码，是动态的的。不受目录改变的限制(ADO and VC operation datagrid source control is the dynamic. From the directory to change the restrictions)

此demo包含vc操作Access数据库的链接、以及增删改查的基本操作，均提供的有接口，方便用户操作，并且提供了一些模糊查询语句供用户参考~~(This demo contains the Access database, the link vc operations, as well as additions or deletions to change the basic operation of search are provided with interfaces, user-friendly operation, and provides a number of fuzzy query for the user' s reference ~ ~)

对已经存在的Accsess数据库表添加新字段并复值(right Accsess already existing database table and add a new field of Complex)

visual basic和access 数据库开发实例 (vb access database)

VisualBasic实现EXCEL数据的批量导入,(EXCEL data batch import to mdb based on VB)