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
