[Libreoffice-bugs] [Bug 91190] Import from Access-Databases: only tables imported

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=91190

--- Comment #5 from Henri <bug at intergga.ch> ---
(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)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171023/571964c5/attachment.html>