Welcome to Dream.In.Code
Getting Help is Easy!

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




A way to load a excel data sheet to My sql 5.0

 
Reply to this topicStart new topic

A way to load a excel data sheet to My sql 5.0

sattua
20 Jul, 2008 - 11:46 AM
Post #1

New D.I.C Head
*

Joined: 20 Mar, 2008
Posts: 27


My Contributions
I have a homework about loading a data sheet from excel to My sql , I dont know how to do it... please give me a clue... what can i use or something??
User is offlineProfile CardPM
+Quote Post

PsychoCoder
RE: A Way To Load A Excel Data Sheet To My Sql 5.0
20 Jul, 2008 - 12:38 PM
Post #2

using DIC.Core;
Group Icon

Joined: 26 Jul, 2007
Posts: 8,983



Thanked: 125 times
Dream Kudos: 8525
Expert In: VB, VB.Net, C#, SQL, ASP, ASP.Net, Web Development, HTML, CSS, Win32 API, Javascript, mySQL, J#, Boo.Net

My Contributions
Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Please post like this:

Thank you for helping us helping you.

You can use the LOAD DATA command in mySQL for this. That should at least get you started smile.gif
User is online!Profile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/1/08 05:24PM

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month