You can also try to export the DB records into CSV (Comma Separated Values) then import into MySQL. Though this might be a lowlevel method but so far, this has worked seamlessly. CSVs can be manipulated/read directly either through PHP, SQL(POSIX,ANSI,etc), or any scripting language since CSVs are just plain text files.
Thought this might be an area than you can also look into should direct migration using tools from Access to MySQL will be a pain for you. I dunno if the DB gurus will agree but just my one cent. Now, back to my review :) On 4/12/07, Archangel <[EMAIL PROTECTED]> wrote:
it was in my plan to start from scratch, but i just cant do that, the company has an existing database in MS Access and they want to make it online, and they where also planning to transfer to MySQL. Since they have an existing database(with more than 100k rows), I just need to convert it.. :D
-- "A dog that has no bite, barks loudest." Registered Linux User #400165 http://baudizm.blogsome.com http://phossil.ifastnet.com Subscribed to: LARTC, Open-ITLUG, PRUG, KLUG, sybase.public.ase.linux SHA256: 857dd62339c9fe27460b725747dfe25d5612933f7d879c35fb0cba2dadaf972f
_________________________________________________ Kagay-Anon Linux Users' Group (KLUG) Mailing List [email protected] (http://cdo.linux.org.ph) Searchable Archives: http://archives.free.net.ph
