Method and device for importing Excel data into database, computer equipment and storage medium

A data import and excel technology, applied in the field of data processing, can solve problems such as inability to see Excel data intuitively, data data import, etc., and achieve the effect of improving user experience, improving efficiency, and facilitating operation

Inactive Publication Date: 2018-09-04
PING AN TECH (SHENZHEN) CO LTD
View PDF3 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method cannot intuitively see the results of converting Excel data into Oracle data. You can only view the relevant imported data by opening the Oracle database after importing.
When the Excel data type converts the Oracle data type to an error that cannot be converted, the above method cannot continue to import the data after modifying and deleting the data that needs to be processed during the import process according to the needs, but can only modify the Excel data and then restart reimport

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 and device for importing Excel data into database, computer equipment and storage medium
  • Method and device for importing Excel data into database, computer equipment and storage medium
  • Method and device for importing Excel data into database, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0028] It should be understood that when used in this specification and the appended claims, the terms "comprising" and "comprises" indicate the presence of described features, integers, steps, operations, elements and / or components, but do not exclude one or Presence or addition of multiple other features, integers, steps, operations, elements, components and / or collections thereof. It should also be understood that the term "and / or" used in the ...

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 embodiment of the invention provides a method and a device for importing Excel data into a database, computer equipment and a storage medium. The method comprises the following steps that: throughan Excel VBA (Visual Basic for Applications) program, connecting Excel with a relational database; setting a corresponding relationship between a field in the Excel form and a field in the corresponding table of the relational database; analyzing the relevant attribute of the field in the corresponding table of the relational database; according to the corresponding relationship and the relevantattribute of the field, determining a conversion rule; utilizing the conversion rule to convert the value of the corresponding row of the field in the Excel table into the value of the corresponding row of the field in the corresponding table of the relational database according to the conversion rule, and displaying a conversion result in the Excel; and importing the conversion result into the relational database. By use of the embodiment of the invention, data importing efficiency can be improved, and user experience is improved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method, a device, a computer device and a storage medium for importing Excel data into a database. Background technique [0002] Because there are differences between Excel data types and relational data such as Oracle database types, data conversion is required when importing data in Excel tables into Oracle databases. Before importing data, Oracle will import the corresponding data content from the Excel table according to its own data type for data conversion, and judge the data that does not meet the requirements to prompt, and finally import the converted data that meets the Oracle data type into the Oracle database. This method cannot visually see the results of converting Excel data into Oracle data. You can only view the related imported data by opening the Oracle database after importing. When the Excel data type converts the Oracle data type to an error that ...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/254
Inventor 占锐
Owner PING AN TECH (SHENZHEN) CO LTD
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