Go Back   CodingForums.com > :: Server side development > MySQL
Reload this Page anyway to get contents of a .xls file into a mysql db ?

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 09-14-2002, 06:16 PM   PM User | #1
c q
Regular Coder

 
Join Date: Jun 2002
Location: Mumbai, India
Posts: 173
Thanks: 0
Thanked 0 Times in 0 Posts
c q is an unknown quantity at this point
anyway to get contents of a .xls file into a mysql db ?
I have a huuuuuuge .xls file. Is there any shortcut method I can incorporate its contents into mySQL ?
....help ???
c q is offline   Reply With Quote
Old 09-14-2002, 06:59 PM   PM User | #2
Spookster
Supreme Overlord


 
Spookster's Avatar
 
Join Date: May 2002
Location: Marion, IA USA
Posts: 6,220
Thanks: 4
Thanked 80 Times in 79 Posts
Spookster will become famous soon enough
Use Excel to export it as a CSV file and then use phpMyAdmin if you have it to import it into MySQL.
__________________
Spookster
CodingForums Supreme Overlord
All Hail Spookster
Who gave you that Ugging infraction? Yeah that's right it was me!
Spookster is offline   Reply With Quote
Old 09-14-2002, 07:18 PM   PM User | #3
c q
Regular Coder

 
Join Date: Jun 2002
Location: Mumbai, India
Posts: 173
Thanks: 0
Thanked 0 Times in 0 Posts
c q is an unknown quantity at this point
emmm....what might be this phpMyadmin ?
c q is offline   Reply With Quote
Old 09-14-2002, 08:30 PM   PM User | #4
Spookster
Supreme Overlord


 
Spookster's Avatar
 
Join Date: May 2002
Location: Marion, IA USA
Posts: 6,220
Thanks: 4
Thanked 80 Times in 79 Posts
Spookster will become famous soon enough
It's an application written in php to administer MySQl databases

http://www.phpmyadmin.net/

Many web hosts provide it for you. If not you can download and install it yourself.
__________________
Spookster
CodingForums Supreme Overlord
All Hail Spookster
Who gave you that Ugging infraction? Yeah that's right it was me!
Spookster is offline   Reply With Quote
Old 09-15-2002, 06:11 AM   PM User | #5
c q
Regular Coder

 
Join Date: Jun 2002
Location: Mumbai, India
Posts: 173
Thanks: 0
Thanked 0 Times in 0 Posts
c q is an unknown quantity at this point
cannot find server or DNS err
but I also hit a google search and foound the same link...maybe some prob. with their server lol
c q is offline   Reply With Quote
Old 09-26-2002, 08:41 PM   PM User | #6
sebastard
New to the CF scene

 
Join Date: Sep 2002
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
sebastard is an unknown quantity at this point
pypMyAdmin
http://phpmyadmin.sourceforge.net/
sebastard is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


« Previous Thread | Next Thread »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:06 AM.
Advertisement
Log in to turn off these ads.