2
Well, if you can find a module to do what you want, you could probably do what I did with a SQL database I imported data from: I opened it in Access, copied everything into Excel sheets, Saved them in CSV files, and then used this script to import them:
http://dev.xoops.org/modules/xfmod/project/?uniconvert
I have just been modifying it as I go. It was made for the user database, but it can be set up to fill in other tables too with a little code modification.
(It also works for user databases quite well, and comes with an example .csv file. If you follow the format it works perfectly.)
For users just edit the database and .CSV info, drop it in your base directory with the .CSV file, and run it.
For other tables just go through and change the tables and structure to suit your needs.
As for syncing with access? I don't know how that would work. Will access do link tables and import mySQL data? I know it will with SQL. I've never tried with mySQL. I have always just used phpMyAdmin to administrate my mySQL databases. Maybe I'll try access sometime. Might make converting structures easier, if it works.
Magick can never be restrained, but when freely given is thrice regained!
