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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
