?
Solved

Export Excel to MySql using asp.net

Posted on 2005-03-03
12
Medium Priority
?
320 Views
Last Modified: 2012-05-05
Is there anyway that i can export an excel to mysql db using asp.net??

With MSSql2000 i've got an option of exporting excel to sql2000 with DTS but,  can it be done for mysql??
If yes, please show me some examples.... thank you very much!
0
Comment
Question by:dynamicrevolutions
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 2
12 Comments
 
LVL 11

Expert Comment

by:sachiek
ID: 13456419
You can do it by ASP.net features.

i.e get data from MySQL and stroe it in a dataset.

Then you can export dataset to a excel ..

Sachi
0
 
LVL 11

Expert Comment

by:sachiek
ID: 13456421
Let me know if you need a sample for it?
0
 
LVL 11

Expert Comment

by:sachiek
ID: 13456429
Exporting dataset to excel file.  
http://www.dotnetspider.com/technology/kbpages/950.aspx
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 5

Author Comment

by:dynamicrevolutions
ID: 13457649
erm... i mean i need to IMPORT EXCEL information to my MYSQL instead of exporting it out from my MYSQL to excel
0
 
LVL 11

Expert Comment

by:sachiek
ID: 13473999
I think below urls answer your requirements.

http://www.xml.com/pub/p/885
0
 
LVL 11

Expert Comment

by:sachiek
ID: 13474008
Further checking more articles point this same application ..

http://www.stardeveloper.com/articles/display.html?article=2003101901&page=1
0
 
LVL 5

Author Comment

by:dynamicrevolutions
ID: 13474345
Is there an alternative way... i mean beside those application... coz i wanna built my own application

Anyway... Sachiek... thank you!
0
 
LVL 11

Expert Comment

by:sachiek
ID: 13474362
Look like mySQL can directly import from text file or ascii files.

So you can save your excel sheet into csv format and can use mysql import functions to directly import it into the
database.

Hope you got it.

Sachi

0
 
LVL 11

Expert Comment

by:sachiek
ID: 13474369
Further somebody also got free coding for this feature.
http://www.twright.com/mysql/


sachi
0
 
LVL 11

Expert Comment

by:sachiek
ID: 13474375
0
 
LVL 11

Accepted Solution

by:
sachiek earned 2000 total points
ID: 13474377
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question