<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Import from Access-Databases: only tables imported"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=91190#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Import from Access-Databases: only tables imported"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=91190">bug 91190</a>
from <span class="vcard"><a class="email" href="mailto:bug@intergga.ch" title="Henri <bug@intergga.ch>"> <span class="fn">Henri</span></a>
</span></b>
<pre>(1)
I use MS Access 2010 ×64 and have no problem to use any .accdb or .mdb
database. Both formats are fully supported !
(2)
I tried again to import Access databases. MS Office 2010 ×64 is installed with
all necessary drivers as well as the latest version of LibreOffice ×64
(German):
5.4.2.2 (x64) Build-ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4
The tentative to import any Access .accdb database from LibreOffice Base with
following method (translation from German, English wording may be different):
- Connection to existing database - Microsoft Access 2007 - Further - Search -
MS Access 2007 database - MyDatabaseXYZ.accdb - Open - Further - Done - Save As
- MyDatabaseXYZ.odb leads to following error message:
"Connection to Database MyDatabaseXYZ could not be established / Connection
could not be established / Maybe the necessary data provider is not installed"
(without any hint which data provider is missing - note that all components of
MS Office and LibreOffice are installed)
Thus, there is still no possibility of importing the Access data !
In the far past, I could at least see the names of the Access tables before the
crash happened, now not even this…
(3)
Sure I could first export the Access databases into Excel than import the data
from Excel to Base, but I would have first to recreated all tables (a huge lot
of work with many possibilities of errors)</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>