Method for importing Excel data into database

A data import and excel technology, applied in the field of communication, can solve the problems of Excel data aggregation, statistics and storage cannot be realized, and achieve the effect of saving work time and improving work efficiency

Inactive Publication Date: 2014-04-23
BEIJING SHENZHOU PUHUI TECH
View PDF5 Cites 57 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, it is still not possible to fully automatically

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for importing Excel data into database
  • Method for importing Excel data into database
  • Method for importing Excel data into database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] The technical solution of the present invention will be described below in conjunction with the accompanying drawings. Apparently, the accompanying drawings describe only a part of the present invention rather than all embodiments.

[0018] Such as figure 1 As shown, a kind of method that Excel data is imported into database provided by the present invention comprises the following steps:

[0019] 101. The database system establishes an Excel report template configuration file, which is used to define the name of the Excel report template, at least one title, and the data type of each title;

[0020] 102. The database system generates an Excel template from the configuration file according to the download request and provides downloading;

[0021] 103. Import data to the downloaded Excel template, and upload the Excel report to the database system after the import is completed;

[0022] 104. The database system automatically saves the data of the Excel report to the d...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a method for importing Excel data into a database. The method includes the following steps: firstly, enabling a database system to establish Excel sheet template configuration files which are used for defining the name of Excel sheet templates, one or more titles and data types of the titles; secondly, enabling the database system to establish Excel templates and provide downloading by the Excel sheet template configuration files according to downloading requests; thirdly, importing data to the downloaded Excel templates and uploading Excel sheets to the database after importing; fourthly, the Excel sheet data is automatically stored in the database by the database system. The method has the advantages that the template is overall established by the database system, the overall data import of the unified templates can be achieved by users and finally automatic data import, statistics and comparison by the database can be realized, thereby saving working hours and improving working efficiency.

Description

technical field [0001] The invention relates to the technical field of communications, in particular to a method for importing Excel data into a database. Background technique [0002] Excel is one of the commonly used office software, which is often used for various data processing and statistical analysis. In many occasions, users often need to count, save, and analyze a large amount of Excel data. It is every user's need to complete these tasks as quickly as possible. Although Windows comes with a large number of shortcut operation methods, it can reduce the time of the above-mentioned processing process. However, it is still impossible to realize the summary, statistics and storage of Excel data fully automatically. Contents of the invention [0003] In view of this, the present invention provides a method for importing Excel data into a database to solve the above-mentioned deficiencies in the prior art. [0004] In order to achieve the above object, the technical...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
CPCG06F16/258
Inventor 尹思剑马美强邓春光
Owner BEIJING SHENZHOU PUHUI TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap