chefsmart wrote: > You may follow these steps: > > 1. install the MySQL ODBC connector (currently version 5.1) > 2. create an empty database > 3. create a DSN pointing to your newly created empty database > 4. open your .mdb file in Access > 5. select your table in Access and go to File->Export... > 6. In the "save as type", choose ODBC databases(), give a name for the > table in mysql, and then choose your DSN created in step 3 above. > > That's all. > > On Jun 9, 7:38 am, Julien <[EMAIL PROTECTED]> wrote: > >> The MySQL migration toolkit has worked quite well for >> me:http://www.mysql.com/products/tools/migration-toolkit/ >> >> On Jun 9, 10:23 am, bacccr <[EMAIL PROTECTED]> wrote: >> >> >>> also, you can export your data from access to xml (within vb) file and >>> then load it into your mysql db with python. there is a lot of >>> options, select the way you familiar with. >>> >>> On 9 июн, 04:30, "Jeffrey Johnson" <[EMAIL PROTECTED]> wrote: >>> >>>> Use access on your Windows PC, Get the ODBC drivers for MySQL, map the >>>> tables and copy the data in by hand. >>>> >>>> Jeff >>>> >>>> On Sun, Jun 8, 2008 at 10:54 AM, M.Ganesh <[EMAIL PROTECTED]> wrote: >>>> >>>>> Hi All, >>>>> >>>>> I am looking for tools/methods to read(if possible also write) data from >>>>> .mdb files which are copied into my linux box with python. I require >>>>> this for coercing existing legacy data into MySQL with some change in >>>>> the data structure. The ultimate aim is to replace an application >>>>> developed in VB with django >>>>> >>>>> Thanks in advance >>>>> Regards Ganesh >>>>> Hi Jeffery, bacccr, Julien, chefsmart & Garrett,
Thanks for all your responses. All the suggested methods are suitable for one time migration. Actually I am planning to migrate from VB to django in phases. So I may have to update data many times. i.e first export a few tables (doing some re-arrangement). After it settles down, export few more tables, as well as the new data entered in the phase I tables through the VB app. Basically one-time-export-of-tables will not work for me. So, if only I can access 'ms access' tables through python, I can write a few functions to check if the data has already reached MySQL table, if not add it. The actual .mdb files are in a Windows box, so if the setup will require a Windows box it is okay, but it will be convenient if I can copy those .mdb files to my linux box, do the initial developement and testing and finally point the functions to the original .mdb files. In short I am looking for a way to read(/write) tables in a .mdb file, through python. Any pointers? Thanks for your time once again Ganesh --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
