SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jun 2003
    Location
    Stockholm
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Import data to MySQL

    Hello,

    I really need your help about the following topic.
    I have a database with one table with about 5000 entries and I would like to import them to my MySQL database which is made with 10 tables. I am getting worried about the feasibility of the importation. I give you a simplified example below:

    *** Excel Database ****

    Firm / Job / Family Name / First Name / Adress / Zip Code /

    *** MySQL Database ****

    - tblFirm
    IdFirm / strName /

    - tblJob
    IdFirm / IdPerson / strJob /

    -tblPerson
    IdPerson / Family Name / First Name / Adress / Zip Code /

    So as you see the problem is in filling the tables tblFirm and tblJob. Using the import function of MySQL I may be able to import the datas for tblPerson easily but I don't see how to fill in tblFirm and tblJob. Is anyone can help me with this? do you think XML can help me with this.
    Thank You very much !!

  2. #2
    SitePoint Guru
    Join Date
    Jan 2001
    Location
    Alkmaar, Netherlands
    Posts
    710
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sounds like you need to write a custom conversion tool


Bookmarks

Posting Permissions

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