SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member
    Join Date
    May 2002
    Posts
    20
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Access/Excel to MySQL

    What is the easiest way to convert either access or excel data to mysql?

    Thanks in advance

  2. #2
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Export the data as CSV files and import it directly into prepared MySQL tables.
    Wayne Luke
    ------------


  3. #3
    SitePoint Zealot
    Join Date
    Oct 2002
    Location
    Germany
    Posts
    159
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by W. Luke
    Export the data as CSV files and import it directly into prepared MySQL tables.
    what do you mean by prepared MySQL tables. do i just need to create the table structure?

    also, how do i import the cvs file using phpMyAdmin? oh and i am having to do this on a windows server.

    thanks for the help!

  4. #4
    SitePoint Enthusiast
    Join Date
    Oct 2001
    Location
    location location
    Posts
    89
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You could create a CSV file or you could install MyODBC and just export the tables from Access/Excel. It can mess up the field definitions but you can pretty easily change the field definitions by hand after you've done the export.

  5. #5
    SitePoint Zealot
    Join Date
    Oct 2002
    Location
    Germany
    Posts
    159
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by m1l
    You could create a CSV file or you could install MyODBC and just export the tables from Access/Excel. It can mess up the field definitions but you can pretty easily change the field definitions by hand after you've done the export.
    hmmm... i think i'll have to check out MqODBC. that is available from the mqsql web site, right?

    i did create a .cvs file. but i could not get it to import correctly. by my understanding, there most likely was a problem with the table that i created. i tried it using a txt file as well.

    anyways, thanks for the info!


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
  •