|
populating MySql database from ms access db...
|
| hello everyone, i need help. we have 2 tables containing 8000 records, the latter having 12000. we have to come up with a desired output(selected columns from the two tables) by joining the two tables. now i have a problem in retrieving values from an ms access database to mysql using a php script. the first thing that we did, since there is no IIS installed on the computer as well as an access driver, we exported the access file as a text file (in CSV) then on the php script, we exported the values to mysql but the values won't appear. btw, we already have a php script that displays the desired output from access and our only problem is how we export it to mysql. guys, what do you think? |
|
Re: populating MySql database from ms access db...
Link |
by
on 2009-05-27 20:30:03 |
|
Are you trying to insert all your data from Access into MySQL? If so can you export the data from Access as an SQL formatted query? Also, I found this tool which could do the trick, provided you figure out how to use it. http://www.sqldbu.com/eng/sections/tips/mysqlimport.html |
|
Re: populating MySql database from ms access db...
Link |
by
on 2009-05-27 21:10:25 (edited 2009-05-27 21:10:35)
|
|
I think you mean to say "import into MySQL". You have tables in MS Access that you want to put in MySQL, right? Like Psoplayer said, you will want to INSERT the rows, or use mysqlimport. 
|
|
Re: populating MySql database from ms access db...
|
| wow thanks for the replies, hope it didn't bother you both. yeah sorry, what i meant there was import the whole thing to mysql. well ive tried that before, using the LOAD DATA INFILE syntax, but it didn't work. anyway i've got the problem solved already, so i think this case is closed. i used a msaccess-mysql converter and then i manipulated the rows in php. thanks guys!! :D |