Welcome Guest ( Log In | Register)



 
 Reply to this topicStart new topic
> Import From Excel File Into Mysql Database
csmith
post Sep 25 2005, 06:05 AM
Post #1


Newbie [Level 1]
*

Group: Members
Posts: 11
Joined: 25-September 05
Member No.: 12,225
Has anyone tried using the excel import function that comes with phpmyadmin http://www.phpmyadmin.net/home_page/ - it does not require any additional plug-ins or scripts and is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish to import the data to , there is a link on the bottom left corner which says "insert data from a text file into the table" - although it says text file it still can be used to import an excel file. When you click on this link you will be taken to a page where you will be asked for the file name (the excel file should be saved as a csv file), how the fields in the file are terminated (you would change this to a "," without the quotation marks), and other data formatting attributes (these are usually left blank). I have never found any problem when using this

(list)

Go to the top of the page
 
+Quote Post
FLaKes
post Sep 25 2005, 06:14 AM
Post #2


Trap Grand Marshal Member
***********

Group: [HOSTED]
Posts: 1,130
Joined: 19-May 05
From: Mexico
Member No.: 7,234
Cool, I just wish you coulve posted this like a couple of months ago. A friend who is a programmer had to make a little php program that would import a huge excel file into phpmyadmin. He first exported the excel as text and then run it through his program and everything was loaded into phpmyadmin. This method wouldve saved us a lot of time.

(list)

Go to the top of the page
 
+Quote Post
vitrus
post Oct 8 2005, 02:47 PM
Post #3


Newbie [Level 3]
***

Group: Members
Posts: 42
Joined: 8-October 05
From: Haarlem, The Netherlands
Member No.: 12,672
Hmmzzz I wil start working with that soon.
I once started a website that was using excell as a database (only to view not to change) ..

So all people in one company could look at the same data via intranet (php)...

(list)

Go to the top of the page
 
+Quote Post
Trap FeedBacker
post Apr 11 2008, 05:52 PM
Post #4


Guest Feedbacks
***************

Group: Members
Posts: 2,360
Joined: 21-September 07
Member No.: 50,369
Import From Excel File Into Mysql Database using Java
Import From Excel File Into Mysql Database

I have to create a java desktop application that upload/loads the data from the MS Excel file (which is also on the desktop) into the specified table in a MySQL DB..

(list)

Go to the top of the page
 
+Quote Post
Trap FeedBacker
post Apr 16 2008, 01:12 PM
Post #5


Guest Feedbacks
***************

Group: Members
Posts: 2,360
Joined: 21-September 07
Member No.: 50,369
So is it possible to transfer a database on MYSQL to another one using this method?

Regrads
Visual basic guide
Http://www.Visualbasicguide.Com

-question by Edison

(list)

Go to the top of the page
 
+Quote Post
Trap FeedBacker
post Apr 28 2008, 01:08 AM
Post #6


Guest Feedbacks
***************

Group: Members
Posts: 2,360
Joined: 21-September 07
Member No.: 50,369
how to import excel file to the database in php
Import From Excel File Into Mysql Database

Hi every body,,does any body can help me?in regards in importing an excel file to the data base in php language.Atually am building on it but theres nothing was there in my database

-reply by jai2

(list)

Go to the top of the page
 
+Quote Post
« Next Oldest · Web Design · Next Newest »
 

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Mysql Infos(2)
  2. Mysql Tool(0)
  3. Mysql And Ms Access(1)
  4. What If You Forget Mysql Root Password(2)
  5. File Upload From Url(3)
  6. Free Dhtml Menu That Reads A Database(7)
  7. Mysql Host Adress(4)
  8. Php And Mysql Problem(8)
  9. Tips On Creating Your Own Search(1)
  10. I Need Help With Attaching A Keylogger 2 A File How Do I Do It?(4)
  11. Looking To Host Music .mp3 File(8)
  12. Syndicate Your Content Using Php And Mysql(0)
  13. Phpbb And Mysql Relations?(2)
  14. How Do You Combine Multiple Mysql Databases Into One Database?(3)
  15. Resizing A Quicktime File ?(6)
  1. Help Or Advise Needed For Access Database Webpage Conversions(0)
  2. Merging Database Php Mysql(5)
  3. How Do I Import Video In Flash(2)
  4. Help With Database(24)
  5. How To Use Html In Flash(1)
  6. Where Am I Going Wrong This Time?(4)
  7. Which Data Type To Use In Mysql Table(4)
  8. Another Question On Mysql Table Data Type(1)
  9. Accessing Mysql From Javascript(4)
  10. Mysql + Php Question(4)
  11. Treating .csv Files As Database Data(2)
  12. How Many Times Was The File Taken?(5)
  13. Index In A Mysql Database(3)


 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 12th May 2008 - 10:08 PM
Powered By IP.Board © 2008  IPS, Inc.
Licensed to: Xisto Corporation