Results 1 to 2 of 2

Thread: Data Import into MySQL

  1. #1
    Join Date
    Sep 2007
    Location
    NCSU
    Posts
    1

    Data Import into MySQL

    I'm working a job for a guy who's got a rather extensive database of business listings that I need to get into an SQL database. What I'm faced with is how to import that huge chunk of data. He and his partner will reformat it however they need to so I can just pretty much click and import it, but I'm trying to figure out a good way to go about this. Basically, is there an easy way for them to arrange the data in something simple like Excel or Access and I just convert that to a .sql and import it?

  2. #2
    Join Date
    Aug 2007
    Posts
    104
    You won't be able to convert an excel data file into a .sql file - that won't work at all. .sql files need much more info inside of them.

    However, you will be able to import an excel file into a MySQL database. You just have to do some prep work first but it will work.

    Here is a link that explains exactly how you can do it:

    http://www.unixreview.com/documents/s=8472/ur0307c/

    Good luck.

    RalphF
    http://www.1849webhosting.com

Similar Threads

  1. Retrieving data from MySQL basic PHP
    By WongFei in forum Client & Server Side Scripting (PHP, ASP, JavaScript)
    Replies: 0
    Last Post: 10 Feb 2007, 03:17 PM

Posting Permissions

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