Can u provide me JAVA code for Extracting Excel data and store it in SQL server using OLEDB 12.0

Question

1.00/5 (5 votes)

See more:

I am not getting any clue how I can extract the Excel Data and store it in SQL server table using JAVA. I dont know whether there are any API's in java or not.

I dont want to Convert EXCEL file to CSV or Iterate the whole file. I want to do it by Microsoft ACE OleDB 12.0

I have 32-bit OS(Windows 07), 32 bit MS Office 2010 and 64 bit SQL Server 2008.

Please help me with some links or java code examples.

I dont want to traverse the whole Excel file. I didnt find any solution where i can achieve it using OLEDB.

Posted 3-Aug-15 0:12am

Member 11789599

Updated 3-Aug-15 5:45am

v2

Add a Solution

Comments

Kornfeld Eliyahu Peter 3-Aug-15 6:27am

No.
But you may show us what have you tried...[^]

Member 11789599 3-Aug-15 11:40am

I didnt find any solution over this. Using C# with OleDB we can achieve this. But is there any API in java to do this?

[no name] 3-Aug-15 7:22am

www.google.com will provide you links and example code. We are not a write code to order service.

Member 11789599 3-Aug-15 11:38am

sorry, i didnt find any solution in google thats why i asked. I need to know whether there is any API or not. Using C# we can do that, but i dont know about java. Thanks for your comment.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2015-08-03T03:27:00

Solution 1

See https://www.google.com/search?q=java%20read%20excel[^].

Posted 3-Aug-15 3:27am

Richard MacCutchan

Comments

Member 11789599 3-Aug-15 11:47am

Thanks for your comment. But i dont want to traverse the Excel file. I just want to know whether java has the solution to achieve this using OLEDB. Using C#, it is possible i know.

Richard MacCutchan 3-Aug-15 11:59am

No not directly, you would need some bridge between Java and .NET.

Mohibur Rashid 3-Aug-15 22:08pm

How about https://www.google.com/search?q=java+oledb