Am 19.12.2012 12:45, schrieb Graham Wing: > Hi there, > why can't I copy an access database into Opensource, and then be able to > update it? > I have to convert the darabase into excel but of course I loose the > facilities of access > Kind regards, > Graham Wing ACQI > Office: 01787371331 > Fax: 08704581636 > Mobile: 07711162621
There are different ways to migrate an access-database to a Free Software database. This is the way I would choose. The first thing you have to do is to choose a free database management system (dbms). If you like a server-client-system the build-in HSQL is not the right one. But they are MySQL and PostgreSQL (for example). The second step (export) is to migrate the data in csv-files (csv = character separeted values) table by table. Control the results! The next step is to create a database in the choosen dbms with the right format of tables and columns. That is the step you need some experience in databases. And the last step is to import the csv-files table for table in the new database. Control the results! In openoffice you have to create a database connection (if you use a server-client-system). Then you have to make queries, formulars, reports and all the other stuff. Regards Michael
signature.asc
Description: OpenPGP digital signature
