Welcome Guest!

If you do not have an account yet on The Web Squeeze forums, please Register! It’s FREE and there are many benefits:

  • Receive Fast Advice
  • Learn Programming Languages
  • Get Professional Website Reviews
  • Quick Troubleshooting Assistance

> Export Xls To Mysql

This is a discussion on Export Xls To Mysql, within the MySQL section. This forum and the thread "Export Xls To Mysql" are both part of the Programming Your Website category.

 
 Reply to this topicStart new topic
> Export Xls To Mysql
Monie
post Jun 16 2008, 12:30 AM
Post #1


Squeeze Machine
*****

Posts: 732
Joined: 13-February 08
From: Borneo
I know how to do that for xsl to access..
but what about xls to mysql?
Anyone know how to do that?

Thanks...


--------------------
Go to the top of the page
 
+Quote Post
Antti
post Jun 16 2008, 12:44 AM
Post #2


Rapid Squeezer
Group Icon

Posts: 307
Joined: 15-February 08
From: Finland
I tried to search for an answer and found this discussion: http://forums.mysql.com/read.php?79,1888,2313#msg-2313
If you don't have any relations already in the table then that could work. Otherwise read the whole discussion and try to find a solution from there.


--------------------
anttisimonen.com | my blog
Go to the top of the page
 
+Quote Post
Monie
post Jun 16 2008, 12:49 AM
Post #3


Squeeze Machine
*****

Posts: 732
Joined: 13-February 08
From: Borneo
I did some research as well and found out that this program will be able to do that: Navicat
Downloading....

Thanks for the link, I will see if it solve the issue biggrin.gif


--------------------
Go to the top of the page
 
+Quote Post
Rakuli
post Jun 17 2008, 08:29 AM
Post #4


Squeeze Machine
Group Icon

Posts: 764
Joined: 13-February 08
From: Catching the squeezed drips downunder.
I have found that one of the easiest methods to export xls to SQL is to export the spreadsheet as a CSV file and import the CSV into a readily available database tool like phpMyAdmin.

Being able to export to standard SQL would be handy though, will have a look at that link wink.gif


--------------------
Luke Dingle . com

Turn Over a Playful Leaf on Web Design -- read about the javascript cat
Go to the top of the page
 
+Quote Post
Monie
post Jun 24 2008, 11:31 PM
Post #5


Squeeze Machine
*****

Posts: 732
Joined: 13-February 08
From: Borneo
I have tried the program and i liked it biggrin.gif
Here is a screen shoot of what the program can do (Export Database).
Attached File(s)
Attached File  Export.JPG ( 42.13K ) Number of downloads: 4
 


--------------------
Go to the top of the page
 
+Quote Post
« Next Oldest · MySQL · Next Newest »
 
If you found The Web Squeeze to be helpful, please donate so we can keep this site FREE, FRESH, and fortified with Web Design & Development info!
 Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Collapse

> Similar Topics

    Topic Title Replies Topic Starter Views Last Action
No New Posts   4 Jason 267 15th February 2008 - 05:54 PM
Last post by: Linda
No New Posts   3 thewal 402 19th February 2008 - 03:32 PM
Last post by: JasonStanley
No new   14 JustinStudios 367 17th March 2008 - 12:04 AM
Last post by: Monie
No New Posts   2 Jason 246 19th May 2008 - 02:43 PM
Last post by: rewake
No New Posts   2 Monie 240 14th July 2008 - 03:42 AM
Last post by: Monie