MS access (.mdb) to drupal migration using navicat-tool

i had do my social networking plattform to drupal.

first i checked a few modules to do the import. but it was much easier to do it this way:

i did the database migration the following way:

- create views with the same fields then in drupal. for some fields i had to use default values.
- converting title fields to delete html-code in title field (vb function in access)
- i used a tool called navicat (www.navicat.com) to do the imports (it have quite a good import function - including insert and append - from many different databases)
- after that i run a few scripts to update the fields (eg. set default user picture, convert date fields to unixtimestamps, ...)

i hope it helps.