Alter-Table

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

sqlite数据库C源码接口程序,通过此程序可以创建,修改和删除SQLITE数据及数据(sqlite database C source interface program, through this process can create, modify, and delete data, and data SQLITE)

说明：  DAO读写(literacy DAO)

This is certification dumbs for db2 version 9.

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

PowerBuilder的一些实例，适合初学者学习使用(Learning source code)

memory mapped noSQL database engine

一个可以打开 SqlCe 数据库文件, 输入 SQL 进行查询的小工具.(SqlCe client tool.)

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