0

How to connect Excel(2010) with Mapinfo(10.0)? I saw that Excel can be connected using Excel as Data Source but my Data Source is already MS-SQL. Actually I would like to reflect any changes in excel to mapinfo and MS-SQL database.

1

Where are your real data? In excel or ms-sql? MapInfo should be able to connect to both, but probably not to an excel-file linked to ms-sql.

  • My real data is in Excel but I store it in MS-SQL too. Actually the changes are implemented in Excel and then uploaded to MS-SQl using mapinfo. – kinkajou Aug 17 '11 at 10:34
  • You can link to the excel file from within MapInfo (see documentation). But you will have read-ony access and you are not allowed to have the xls file open in Excel at the same time. – Uffe Kousgaard Aug 17 '11 at 13:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.