Subscribe to this thread
Home - General / All posts - import file table excel with image ( mfd8 test)
lionel

476 post(s)
#31-Oct-18 23:22

Hi

I try to import in manifold 8 and excel file of country that contain the european country flags and some icon ( valid = enable) .

When i do this i have this message

---------------------------

Manifold System

---------------------------

Can't establish connection to data source: error binding to data source.

---------------------------

OK

---------------------------

Is there a way to import image in manifold 8 or manifold 9 from an excel file that contain images ?

i l ltry to see if there is a setting in excel that make manifold import excel fine and RTFM manifold8 and 9 !!

Attachments:
country_img.xlsx
manifold8_importexcelimg.png


join image "Because my dad promised me" interstellar from Manifold: Time by Stephen Baxter. power Math destruction

lionel

476 post(s)
#01-Nov-18 02:43

i test with basic excel file ( no image) and updaTe manifold 8 to last version and same error ;

perhaps a excel version problem !! to be test !!


join image "Because my dad promised me" interstellar from Manifold: Time by Stephen Baxter. power Math destruction

ColinD


1,880 post(s)
#01-Nov-18 05:55

You must use 32-bit to import an excel file because that's what the Microsoft Jet drivers are. There is a 64-bit data base engine that can be installed but it is not compatible then with Excel.


Aussie Nature Shots

Dimitri

5,082 post(s)
#01-Nov-18 08:45

Correct. There is a discussion of that in the Importing Tables topic in the Release 8 documentation:

Important Note when Using 64-bit Manifold Editions

Due to a lack of required Microsoft facilities in 64-bit Windows systems, Manifold in 64-bit mode cannot export, import, export or link to DB, HTML, MDB, XLS or WKx format files. This includes no access to the MDB parts of Manifold MFD and MapInfo TAB imports. The workaround for importing or exporting such files is to launch Manifold in 32-bit mode by using the Manifold System (32-bit) shortcut, perform the export from or import into a .map project file and then re-launch Manifold in 64-bit mode using the Manifold System (64-bit) shortcut. Linking is more complex: the data must be in some format usable in 64-bit mode within 64-bit Windows systems, such as a SQL Server database. Alternatively, the data can be kept within a Manifold .map project file and linked using the Manifold ODBC driver.

Release 9 has a more explicit warning at the top of the XLS .xls, XLSX .xlsx topic.

Manifold User Community Use Agreement Copyright (C) 2007-2017 Manifold Software Limited. All rights reserved.