School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Welcome to Dream.In.Code
Become an Expert!

Join 300,464 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,688 people online right now. Registration is fast and FREE... Join Now!




Transferring Excel Contents to SQL Server 2005

 

Transferring Excel Contents to SQL Server 2005

smitaborhade

19 Jun, 2009 - 04:04 AM
Post #1

New D.I.C Head
*

Joined: 19 Jun, 2009
Posts: 4

Dear All,

I am trying to transfer the data contents of a huge Excel file into SQL server using Java.
I need to design a Web portal where in , user will have to specify the Excel File in the browse text box, and upload data into the sql server.

Method tried: used a SSIS Package, designed a package, used a stored procedure to fire it, and then i was trying to fire it using Java.
However , i was unable to do so, using this approach.

Please suggest, if you have a better approach for the same.

Thanks in advance!!!!!


User is offlineProfile CardPM
+Quote Post


jjsaw5

RE: Transferring Excel Contents To SQL Server 2005

19 Jun, 2009 - 05:04 AM
Post #2

I must break you
Group Icon

Joined: 4 Jan, 2008
Posts: 2,656



Thanked: 25 times
Dream Kudos: 125
My Contributions
You posted this question 4 times in 4 different threads. Understanding that you are new here please DO NOT double post your questions.

If you're not sure where a question belongs post it in where you think it is suited and if we feel it is better suited for another thread we will move it.

Thank you.
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 11/8/09 02:29AM

Live Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month