transfer MS Access DB files to Ubuntu MySQL
I would like to transfer my Access database files to MySQL in Ubuntu and use Open Office Base to manage them via ODBC
I can export export my MSAccess databases from Access to MySQL in XP and copy the resulting MySQL data files to my shared drive, reboot into Ubuntu 6.10, and see the files, but I can't then pick them up in MySQL in Ubuntu. They don't look like the data files stored in Ubuntu. So, I've been exporting the MySQL tables to tab delimited text files, which I can then pick up in MySQL on the Ubuntu side; although this is very slow.
Once I get the data into MySQL on the Ubuntu side, I try to connect via ODBC but can't manage to find the data. I have instructions for doing this in an apparently earlier version of Ubuntu, but the drivers don't seem to apply to 6.10.
Does anyone know how to do this?
Access is the only reason I'm keeping XP on this dual boot machine.
Thanks.
Question information
- Language:
- English Edit question
- Status:
- Solved
- For:
- Ubuntu Edit question
- Assignee:
- No assignee Edit question
- Solved by:
- jamescw
- Solved:
- Last query:
- Last reply: