International Journal of Advance Computational Engineering and Networking (IJACEN)
.
Follow Us On :
current issues
Volume-11,Issue-12  ( Dec, 2023 )
Past issues
  1. Volume-11,Issue-11  ( Nov, 2023 )
  2. Volume-11,Issue-10  ( Oct, 2023 )
  3. Volume-11,Issue-9  ( Sep, 2023 )
  4. Volume-11,Issue-8  ( Aug, 2023 )
  5. Volume-11,Issue-7  ( Jul, 2023 )
  6. Volume-11,Issue-6  ( Jun, 2023 )
  7. Volume-11,Issue-5  ( May, 2023 )
  8. Volume-11,Issue-4  ( Apr, 2023 )
  9. Volume-11,Issue-3  ( Mar, 2023 )
  10. Volume-11,Issue-2  ( Feb, 2023 )

Statistics report
Feb. 2024
Submitted Papers : 80
Accepted Papers : 10
Rejected Papers : 70
Acc. Perc : 12%
Issue Published : 132
Paper Published : 1541
No. of Authors : 4000
  Journal Paper


Paper Title :
Design And Implementation Of Massive Excel Data Intelligent Import System To Database (Mysql) By Using Libraries

Author :Kamalakant L Bawankule, N B. Raut

Article Citation :Kamalakant L Bawankule ,N B. Raut , (2014 ) " Design And Implementation Of Massive Excel Data Intelligent Import System To Database (Mysql) By Using Libraries " , International Journal of Advance Computational Engineering and Networking (IJACEN) , pp. 75-78, Volume-2,Issue-5

Abstract : Abstract—To import nearly 1,0000 to attribute to the tables of 10-20 column information of students and papers database of Excel format into the target tables of MySQL database, we developed the intelligent import system which distinguished the simple import system. The system uses Netbeans/Eclipse as the development tool, object-oriented language java as the programming language, MySQL as the background database, POI-HSSF as the apache Library for reading data from excel, used AWT and SWING for design of an application ,and uses the mysql-connector as connection technology to database. The system realizes to import the massive data of Excel format into the MySQL database intellectually that convenient for integrating and managing the multiple data required for regular examination process in the institutes and universities.HSSF is the POI Project's pure Java implementation of the Excel '97(-2007) file format. XSSF is the POI Project's pure Java implementation of the Excel 2007 OOXML (.xlsx) file format.HSSF and XSSF provide ways to read spreadsheets create, modify, read and write XLS spreadsheets.

Type : Research paper

Published : Volume-2,Issue-5


DOIONLINE NO - IJACEN-IRAJ-DOIONLINE-746   View Here

Copyright: © Institute of Research and Journals

| PDF |
Viewed - 46
| Published on 2014-05-16
   
   
IRAJ Other Journals
IJACEN updates
Paper Submission is open now for upcoming Issue.
The Conference World

JOURNAL SUPPORTED BY