Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Computer Applications and Software》 2004-10
Add to Favorite Get Latest Update

DATA CONVERSION FROM EXCEL TO DATABASE

Qiu Ning(Information College,Zhejiang Shuren University,Hangzhou 310015)  
Since the wide use of the database system in the office informationlization,how to use the given Excel original data has been becoming a spiny problem.This paper mainly focuses on the data conversion between the Excel sheet and the database system,especially from the complicated Excel sheet,and gives a simple demonstration using Borland Delphi 6.0 and VBA.
【CateGory Index】: TP317.3
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【References】
Chinese Journal Full-text Database 10 Hits
1 LUO Yu-jun(Computer Department of North Sichuan Medical College,NanChong,Sichuan 637007,China);Automatic Data Extraction Based on Metadata[J];Computer and Information Technology;2007-04
2 LI Quanbin1,2,LIU Jingao1(1.Department of Electronic Engineering,East China Normal University,Shanghai 200062;2.College of Physics and Electronic Engineering,Xuzhou Normal University,Xuzhou 221116);High-effect Development of Network Information Sharing System[J];Computer Programming Skills & Maintenance;2009-18
3 XU Bin (Department of Computer and Information Technology, Nanjing Yingtian College, Nanjing 210046, China);Approach for Reciprocal Convertion on DB and Excel[J];Computer Knowledge and Technology;2009-24
4 Chen Yong Information Technique Department,North-Western Agricultural University,Yangling,712100,Shaanxi,China; Luo Zhiping Guo Mingxin Hubei Entry-Exit Inspection and Quarantine Bureau,Wuhan,430022,Hubei,China;Study on the application of VBA in processing the data of the tetracylines residuces detection in honey products for export[J];Computers and Applied Chemistry;2006-05
5 XU Ling, CHEN Li-xin, KONG Ling-xin;Probe into the Data Transformation Technology——A Kind of Method for Implementing the Conduction of SQL Data into Excel Template[J];Sci-Tech Information Development & Economy;2006-19
6 LUO Jia-guoa,XU Linb,KONG Ling-xinc(Jiangxi University of Science and Technology,a.Dean's office;b.Faculty of Economics and Managerial Science; c.Faculty of Science,Ganzhou 341000,China);On Delphi and SQL Data Conversion Technology[J];Journal of Jiangxi University of Science and Technology;2006-06
7 WANG Xiang-bo, WANG Jia-hua(School of Computer Science, Xi′an Shiyou University, Xi′an 710065, China);Grammar Based Data Exchange Technology Between Excel and Database[J];Microelectronics & Computer;2008-01
8 YANG Qiang-qiang , ZHUANG Cheng-san , SUN Zi-long , DING Ju-ling(Department of Computer Science, Sichuan University, Chengdu 610064 China);VBA Based Implementation for the Receipt and Dispatch of FAX on Internet[J];Modern Computer;2005-06
9 LI Quan-bin1,2,LIU Jin-gao1(1.Department of Electronic Engineering,East China Normal University,Shanghai 200062;2.College of Physics and Electronic Engineering,Xuzhou Normal University,Xuzhou 221116);Design and Implementation of Network Information Sharing System[J];Modern Computer;2009-07
10 LI Jie,NING Fan,ZHAO Guo-An(Beijing University of Posts and Telecommunications,Beijing100876,China);Design and Realization of a Bulk Data Validation Method[J];Computer Systems & Applications;2010-05
【Co-references】
Chinese Journal Full-text Database 10 Hits
1 LIU Rujiu1,2,ZHANG Zhenshan1,CHAI Tianyou1(1.Key Laboratory of Integrated Automation of Process Industry, Ministry of Education,Northeastern University,Shenyang 110004,China;2.School of Mechanical,Electronic and Control Engineering,Beijing Jiaotong University,Beijing 100044,China);A General Method of Data Extraction from Multi-Database and Its Application[J];Journal of Beijing Jiaotong University;2008-04
2 Sun Jiapeng;The application of ActiveX technique in converting Excel form into AutoCAD form[J];Journal of Ship Design;2005-01
3 ;Two Approaches for Outputting Data to Excel in VB Database Programming[J];Computer Development & Applications;2002-09
4 ;VBA技术在动态电子表格中的应用[J];Computer and Information Technology;2001-04
5 WANG Ning-ning (Commercial School Zhanjiang Normal College, Zhanjiang 524048, China);To Print Project and Come True on the Basis of Teaching Assignment Texts[J];Computer Knowledge and Technology(Academic Exchange);2007-02
6 KANG Ya,SHAO Kang,WU Man-yi (Institute of Economy and Management, Anhui University of Science & Technology,Huainan 232001,China);A High-efficiency Method for Switching Excel-data Into Database[J];Computer Knowledge and Technology;2008-16
7 GONG Jian-min, SUN Shou-long, CHEN De-shan (Department of Computer, Dezhou University, Dezhou Shandong 253023, China);Use Excel with VBA to Input Original Data from Traditional Questionnaire into Computer[J];Journal of Dezhou University;2005-02
8 LIU Shao-jun~1,HE Zheng-wei~(1,2),HUANG Run-qiu~(1) , XU Qiang~(1),WANG Hua-jun~1,WU Ya-zi~1 (1.National Laboratory of Geohazard Prevention & Geoenvironment Protection,Chengdu University of r Resource and Geographic Information System,Captial Normal University ,Beijing 100037 ,China);Developing landslide comprehensive forecasting on ArcGIS VBA[J];Journal of Guilin Institute of Technology;2004-03
9 RONG Jun(Guangxi meteorological technical and equipment center ,Nanning 530022);Excel VBA Programming Method and Application on Meteorological Data Processing[J];Journal of Guangxi Meteorology;2004-03
10 CHEN Hua bao 1, HU Yong 2, LIANG Bing 3 (1.Department of Physics,Huaiyin Normal College,Jiangsu,Huaiyin 223001,China; 2.Huaiyin Middle School,Jiangsu,Huaiyin 223001,China;3.Huaiyin Power Plant,Jiangsu,Huaiyin 223001,China);The Conversion for the Form of Data Base is Achieved by VFP[J];;2001-01
【Secondary References】
Chinese Journal Full-text Database 3 Hits
1 WANG Zhe,PAN Mao,GUO Yan-jun School of Earth and Space Sciences,Peking University,Beijing 100871,China;Excel information extraction based on XML metadata and schema[J];Computer Engineering and Applications;2008-33
2 LIN Xiao-yong1 , CAI Li1,2 , CHEN Ji-zhen1 , XIA Jian3 (1. Nanjing University of Posts and Telecommunication, Nanjing 210003 China;2. China Network Communication Ltd Beijing Branch, Beijing 100031 China;3. China United Communication Ltd Jiangsu Branch, Nanjing 210029 China);Design and Realization of IP Fax Server based on CTI Technology[J];Modern Computer;2006-12
3 LU Sheng-en(The administration office of municipal engineering,Yanshi 471900,China);A kind of Management Information System for Intelligent Residential Quarter[J];Microcomputer Information;2009-34
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved