[Solved] Access mdb table, how to import in Calc

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
patel
Posts: 36
Joined: Tue Jun 19, 2012 2:48 pm

[Solved] Access mdb table, how to import in Calc

Post by patel »

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]
OpenOffice 4.1 on Windows 10
LibreOffice 5.2 on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Access mdb table, how to import in Calc

Post by Villeroy »

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
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
patel
Posts: 36
Joined: Tue Jun 19, 2012 2:48 pm

Re: Access mdb table, how to import in Calc

Post by patel »

Thank you very much
OpenOffice 4.1 on Windows 10
LibreOffice 5.2 on Windows 10
Post Reply