On Apr 05, 2012, Mark wrote:
>
>
> One method is to find a decent back end such as MySQL and move
> your table across, while temporarily maintaining your front end in
> Access. MySQL has a migration assistant which may help here.
I have developed a scheme for migrating an Access database to MySQL.
Briefly
1. mdb-export generates a CSV file
2. run a program to convert this into a shell script consisting of
a set of 'insert into' statements
3. run this in MySQL
There are some small details on the way. I can post the script and program
if you think it would be helpful
Tony
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
