Results 1 to 13 of 13
  1. #1
    Join Date
    Apr 2005
    Posts
    46

    Unanswered: Merging data into a table....

    OK, I created a table with phpmyadmin...

    I recently just received an excel database, 50 rows 6 columns (not huge...)
    and now I want to be able to import the tab delimated database into the
    existing table. I have the column names matching in both...but I can't find
    an easy way to just import the database...... please tell me there is an easy
    way to do it, without having to input each row by hand...

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    dunno if this is true in all versions of phpmyadmin, but ....

    click on the table in the left pane

    on the resulting display in the right pane, you see the fields, then the indexes, then the SQL box, then location of textfile (for sql), and at the very bottom, a link that says Insert data from a textfile into table

    click on that and fill in the detials
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2005
    Posts
    46
    hmmm.... I couldn't find anything like that. Do you kno what version you are looking at? I am running 2.7.0-pl2....

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i'm on phpMyAdmin 2.6.0-pl3

    i doubt they'd've removed that feature in a later release

    keep looking, you'll find it
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Apr 2005
    Posts
    46
    is it possible to take a couple of screen shots? The closest thing that I found didn't give me an option to choose my file...

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    here ya go...
    Attached Thumbnails Attached Thumbnails screenshot.gif  
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Apr 2005
    Posts
    46
    OK, I found the page closest resembling that...however, there is no bottom section (Or Location of the textfile...doesn't exist, nor anything below that line)... I also doubt that they would have removed it, the site is being hosted on godaddy.com, do you think it would be some type of permissions or something? I have full access to everything else...

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    it'll be there somewhere, keep looking

    they wouldn't just remove an option like that

    no, it's not a permissions thing, if you can see the table and run queries on it

    do you at least have a left pane that lists your tables? show the screenshot of what you get when you click on one of those tables
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Apr 2005
    Posts
    46
    yes, i have the left pane, and the tabs that you spoke of.... below is a screenshot:

    Click image for larger version. 

Name:	Picture 1.png 
Views:	46 
Size:	86.6 KB 
ID:	5997


    thoughts?
    Last edited by lukeMV; 05-10-06 at 22:17.

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    have a look at the bottom of the Structure tab
    Last edited by r937; 05-11-06 at 08:06.
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  11. #11
    Join Date
    Apr 2005
    Posts
    46
    Click image for larger version. 

Name:	Picture 2.png 
Views:	51 
Size:	161.5 KB 
ID:	6000

    Bottom of structure tab.... no dice.

    Does anyone know of actual mySQL code that could be run from here to do this action?

  12. #12
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    sure, LOAD DATA INFILE
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  13. #13
    Join Date
    Jun 2003
    Posts
    13
    You can try to use such tool as Data Import for MySQL.

    http://www.sqlmanager.net/products/mysql/dataimport
    Last edited by DEkart; 05-17-06 at 07:12.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •