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

Creating a macro - Writing a Script - Using the API

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

Postby patel » Sun Jun 16, 2019 1:34 pm

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

Re: Access mdb table, how to import in Calc

Postby Villeroy » Sun Jun 16, 2019 1:51 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27301
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Access mdb table, how to import in Calc

Postby patel » Sun Jun 16, 2019 6:04 pm

Thank you very much
OpenOffice 4.1 on Windows 10
LibreOffice 5.2 on Windows 10
patel
 
Posts: 25
Joined: Tue Jun 19, 2012 2:48 pm


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 6 guests