[Solved] Access mdb table, how to import in Calc
[Solved] Access mdb table, how to import in Calc
Is it possible via macro ? can you show me an example code ?
Last edited by robleyd on Mon Jun 17, 2019 1:54 am, edited 1 time in total.
Reason: Tagged [Solved]
Reason: Tagged [Solved]
OpenOffice 4.1 on Windows 10
LibreOffice 5.2 on Windows 10
LibreOffice 5.2 on Windows 10
Re: Access mdb table, how to import in Calc
No, it is not possible via macro.
menu:File>New>Database...
[X] Connect to existing
Type MS Access
[X] Register the database (so you can use it with ODF documents)
Save the database.
############################################################
In Calc or Writer open the data source window (F4 or Ctrl+Shift+F4) and drag the table, view or query into your office document.
[Tutorial] Using registered datasources in Calc
menu:File>New>Database...
[X] Connect to existing
Type MS Access
[X] Register the database (so you can use it with ODF documents)
Save the database.
############################################################
In Calc or Writer open the data source window (F4 or Ctrl+Shift+F4) and drag the table, view or query into your office document.
[Tutorial] Using registered datasources in Calc
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Access mdb table, how to import in Calc
Thank you very much
OpenOffice 4.1 on Windows 10
LibreOffice 5.2 on Windows 10
LibreOffice 5.2 on Windows 10