| 利用VBA实现教学计划数据从Excel导入到Access |
| |
| 引用本文： | 邹月亮. 利用VBA实现教学计划数据从Excel导入到Access[J]. 数字社区&智能家居, 2009, 0(31) |
| |
| 作者姓名： | 邹月亮 |
| |
| 作者单位： | 上海大学教务处; |
| |
| 基金项目： | 上海大学教育教学改革研究项目(A.08-0304-07-005) |
| |
| 摘 要： | 教学计划表结构复杂,不仅含课程信息,还包含一些说明信息。该文主要介绍如何利用VBA实现从结构复杂的教学计划Ex-cel表中提取课程信息,然后将该信息导入到Access数据库中。程序共分成两个步骤,第一步从教学计划表中提取课程信息,第二步将该信息导入到Access中。
|
| 关 键 词： | 教学计划 VBA Excel 数据导入 Access |
Induct the Data of Teaching Plan from Excel to Access by VBA |
| |
| ZOU Yue-liang. Induct the Data of Teaching Plan from Excel to Access by VBA[J]. Digital Community & Smart Home, 2009, 0(31) |
| |
| Authors: | ZOU Yue-liang |
| |
| Affiliation: | ZOU Yue-liang(Academic Administration,Shanghai University,Shanghai 200436,China) |
| |
| Abstract: | Teaching plan is complicated,it contains not only course information,but also other comment information.This paper intro-duces how to induct the course information of teaching plan from Excel to Access by VBA.It consists of two steps.The first step is to ex-tract course information from teaching plan.The second step is to induct the course information into Access. |
| |
| Keywords: | teaching plan VBA Excel ingoing data Access |
| 本文献已被 CNKI 等数据库收录！ |
