Excel file to MySQL format

Hello,

I have a question regarding the following:

There is an ms Excel file which when uploaded and sent through internet reaches a server and at the server the information is stored in database as MySQL.

I know jExcelAPI to deal with Excel files and servlets but how to convert an excel file into MySQL format using java.

I have practiced normal database connectivity, JDBC etc.. and that deals with Ms Access files with SQL syntax.

Is this totally different concept?

Plz do help me out.

Thankyou.

[548 byte] By [KayDeEa] at [2007-11-26 14:31:17]

«« How to fing out the input is double value
»» SunFire x4200 - What's eating my RAM?

# 1

Nope you just have to read the excel file using some API (jExcelAPI / POI) or just query it using SQL using "Microsoft Excel Driver" with JDBC-ODBC bridge and then issue SQL statements to MySQL

LRMKa at 2007-7-8 2:26:19 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

forget about any API'shere's what you want to do1. store the file on the file system and store the path to the file (as a varchar) in the database.or2. write the file to bytes and store in a blob

SoulTech2012a at 2007-7-8 2:26:19 >

# 3

> I know jExcelAPI to deal with Excel files and

> servlets but how to convert an excel file into

> MySQL format using java.

> have practiced normal database connectivity, JDBC

> etc.. and that deals with Ms Access files with SQL

> syntax.

> s this totally different concept?

Your question is inprecise.

Do you want to store the file itself or do you want to extract data from the file and store that data?

jschella at 2007-7-8 2:26:19 >

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Excel file to MySQL format

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified