| Excel文件数据的SQL Server导入及其处理 |
| |
| 引用本文： | 郑昌盛,龙伟,黄劼. Excel文件数据的SQL Server导入及其处理[J]. 兵工自动化, 2004, 23(4): 89-90 |
| |
| 作者姓名： | 郑昌盛 龙伟 黄劼 |
| |
| 作者单位： | 四川大学,制造学院,四川,成都,610054;四川大学,制造学院,四川,成都,610054;四川大学,制造学院,四川,成都,610054 |
| |
| 摘 要： | 数据库导入程序及规则化处理方法,针对Excel文件导入SQL Sever数据库因格式转换出错丢弃数据提出.该程序用VB设计,在SQL Server中建立nchar临时数据表,将Excel保存为Unicode字符文本,调用导入导出向导时自动生成结构化存储文件包,运行时调用该文件包将文本文件自动导入SQL Server 数据库并对数据规则化处理.
|
| 关 键 词： | Excel文件 SQL Server数据库 数据导入 数据处理 |
| 文章编号： | 1006-1576(2004)04-0089-02 |
| 修稿时间： | 2004-04-20 |
Importing and Processing Date from Excel File into SQL Server |
| |
| ZHENG Chang-sheng,LONG Wei,HUANG Jie. Importing and Processing Date from Excel File into SQL Server[J]. Ordnance Industry Automation, 2004, 23(4): 89-90 |
| |
| Authors: | ZHENG Chang-sheng LONG Wei HUANG Jie |
| |
| Abstract: | The method of database file importing and data regularization was brought out, aiming at the data losing when data from Excel files was import into SQL Server database for the conversion failure of the data type. This program was compiled with VB, and temporarily nchar type table was created in SQL Server, and Excel files were saved as Unicode files. In running the program the data was imported into SQL Server database by calling the DTS package file generated by the DTS import/export wizard and then process the imported data. |
| |
| Keywords: | Excel file SQL Server database Import data Data processing |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
