EXCELtoMDB

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

说明：  DAO读写(literacy DAO)

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

以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 )

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

数据库功能展示，vc连接access数据库，实现增删查找功能(Database function display, vc connection access database, add or delete search function to achieve)

这是一款用MFC ADO编写的数据库软件，它可以实现对ACCESS数据库的打开，添加，修改，保存，排序得一系列的功能。它利用ListCtl进行显示(This is a MFC ADO with the preparation of the database software, it can be open to the ACCESS database, add, modify, save, sort a series of functions. It uses ListCtl display)

利用MFC开发的数据库系统，用的是微软的Access，有详细的链接数据库的代码。(Use of MFC development of database systems, using Microsoft Access, there are more links to the database code.)

Sqlite3 的确很好用。小巧、速度快。但是因为非微软的产品，帮助文档总觉得不够。这 些天再次研究它，又有一些收获，这里把我对 sqlite3 的研究列出来，以备忘记。(Sqlite3 really good use. Small, fast. But for the Microsoft products, always feel that not enough to help document. This Some day to study it, and have some harvest, here I study on SQLite3 list, to forget.)

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