to_connect_excel

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

说明：  此压缩文件包含2002年-2017年200多个地级市资本存量的数据，里面有详细的计算过程与说明。(This document contains the capital stock data of more than 200 cities in 2002-2017, including detailed calculation process and description, which is convenient for scholars to understand and master)

可用于查看和编辑db3，SQLite的免费软件。(look out "db3", free software.)

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

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

此代码是针对数据库教材的源代码，包括求“输入的两个数的最大公约数和最小公倍数”、“输入工资输出工资水平”。程序在Access上得到了验证，也可以移植到其他数据库上。(This code is aimed at teaching book of source code, including database for "input the two Numbers when the largest and smallest LCD", "input output wages." wages Program in the Access is verified, also can be transplanted into other database.)

这是一款用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.)

这是ACCESS的数据库编程文件，可以容易的用在MFC，VC,DELPH等工程环境(ACCESS ADO DATABASE ,MFC VS2008 AND VS2010)

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