Re: HOW-TO use Microsoft Access databases from within OpenOffice.org 1.1
Hi, Gabriel schrieb: HOW-TO use Microsoft Access databases from within OpenOffice.org 1.1 I need help using Access *.mdb files with OpenOffice 4.0.1 on Windows 8 (Stupid, I know. Win2K does not support touchscreen) Please have a look at https://wiki.openoffice.org/wiki/Connecting_to_Microsoft_Access It was written for older Windows versions, but it might work on Windows 8 too. I haven't got Window 8 and cannot test it myself. It would be nice, if you feed back, what works for you and what not, and what has to be changed for Windows 8. Kind regards Regina - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
HOW-TO use Microsoft Access databases from within OpenOffice.org 1.1
HOW-TO use Microsoft Access databases from within OpenOffice.org 1.1 I need help using Access *.mdb files with OpenOffice 4.0.1 on Windows 8 (Stupid, I know. Win2K does not support touchscreen) - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Databases
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
Re: Databases
YHi Graham, Graham Wing schrieb: Hi there, why can't I copy an access database into Opensource, and then be able to update it? Which database driver do you use? Which operating system? You should have ask on user mailing list or in the forum. Perhaps the tips in http://wiki.openoffice.org/wiki/Connecting_to_Microsoft_Access help you. Kind regards Regina
Databases
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