PDA

View Full Version : Data Import into MySQL



nmaster64
15 Sep 2007, 07:17 AM
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?

1849
15 Sep 2007, 11:05 AM
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