Current location: Hot Scripts Forums » Programming Languages » PHP » How to convert an Exchel sheet into MySQL DB


How to convert an Exchel sheet into MySQL DB

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 08-27-03, 10:00 AM
Ole Nygaard Ole Nygaard is offline
Newbie Coder
  
Join Date: Aug 2003
Location: Copenhagen, Denmark
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
How to convert an Exchel sheet into MySQL DB
Dear All

How can I make PHP script which can convert a pretty large EXCEL sheet (400Kb) into a MySQL DB on my web server - and then have a web interface where I can update all the cell's instantly (only text based - no arithmetic involved).
Several users should have the possibility to update data at the same time.

I am so tired to sending EXCEL sheets in a circle - not knowing who has the latest update/version

Of course it would be very convenient to be able to download a backup of the data in the MySQL DB now and then.

Rgds.
__________________
Ole :-)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #2 (permalink)  
Old 08-27-03, 10:10 AM
Stefan's Avatar
Stefan Stefan is offline
Junior Code Guru
  
Join Date: Jun 2003
Location: Utrecht, The Netherlands
Posts: 599
Thanks: 0
Thanked 0 Times in 0 Posts
afaik, you can export an excel sheet as comma delimitered file and import that in a MySQL table.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
Reply

Bookmarks

« Cgi Error | PHP binary »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

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 Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP and MySQL ? rob2132 Hot Scripts Forum Questions, Suggestions and Feedback 4 08-29-08 03:22 AM
Forum/Board - MySQL = Possible? cipher PHP 7 10-07-03 04:42 AM
great product for dumping/recovering MySQL databases Dave Brown General Advertisements 1 10-03-03 08:40 AM
MySQL with PHP question. HELP for a newbie kenfused PHP 3 08-02-03 01:53 AM
What can I use to update excel sheet on the fly using a browser? mysticwar PHP 1 06-17-03 02:23 AM


All times are GMT -5. The time now is 09:07 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.