This is the MySQL page: http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html
I thought that maybe one of the Php guys might have already written a script that will do this. I thought I'd ask because I don't think that it would be worth it for me to do the research on how to make a script to do this, because I don't really foresee needing it in the future (in spite of the fact that I can use it now) , and also for the fact that I'm sure that some Php 'er' has done it already by now. I just don't know where to find it. Thanks On Thu, Nov 4, 2010 at 11:17 PM, Paul Saenz <[email protected]>wrote: > This is one of the tools I found: > > http://www.howtodothings.com/computers/a3744-how-to-convert-access-to-mysql.html > > other than that, I what I found was on the mysql site. It's complicated and > it describes in detail all of the circumstances that one may encounter for > many different types of db situations with complex data structure and data > type. I thought that maybe someone had experience with something that may be > simple, since I am dealing with a small simple database that only has one > table with text and integers. It's not even really a database, it's just one > table. I'm just hoping that I can migrate it into mysql so I don't have to > copy every field. > > Thanks > > > On Thu, Nov 4, 2010 at 10:24 PM, David Kaiser <[email protected]> wrote: > >> Paul, >> Is this something you're ever going to do more than once? >> >> You probably should just stick to figuring out how to export into some >> type of text format, and then importing that into MySQL. I've never done >> that, so I don't know how hard that will be to figure out. You might have >> to use some sort of graphical MySQL interface which allows you to import >> text files into fields. >> >> I don't know of (but haven't ever looked for) any tools that automate >> this, but if you were really motivated and had free time, there are >> obviously going to be some ETL Tool projects out there. Since you used the >> word simple, I'm guessing that's not what you are looking for. >> >> What have you found by searching on Google so far? >> >> >> >> >> On 11/4/10 10:17 PM, Paul Saenz wrote: >> >> does anyone know of a simple open source tool for importing a small/simple >> access >> database into mysql. The access db only has text and intergers. I'm just >> hoping I >> can find something that I can find a simple little tool to migrate a small >> MS Access >> database into MySQL. I googled it, and I found several, but I'm a little >> leery about >> the possibility of downloading some malicious code. >> >> Thanks >> Paul >> >> >> _______________________________________________ >> LinuxUsers mailing >> [email protected]http://socallinux.org/cgi-bin/mailman/listinfo/linuxusers >> >> >> >> _______________________________________________ >> LinuxUsers mailing list >> [email protected] >> http://socallinux.org/cgi-bin/mailman/listinfo/linuxusers >> >> >
_______________________________________________ LinuxUsers mailing list [email protected] http://socallinux.org/cgi-bin/mailman/listinfo/linuxusers
