MySQL Forums
Forum List  »  General

MySQL for Excel - Compatibility
Posted by: Gary Graynoth
Date: April 30, 2023 04:15AM

We have a lot of new date which is in the form of Excel spreadsheets, which is additional information to be added to an existing MySQL database into existing blank fields.

MySQL for Excel 1.3.8 seems the perfect solution but having installed it, we can't connect to the test database on Localhost. In googling the connection problem, a post was uncovered which indicated that MySQL for Excel 1.3.8 will not work on version 8.0.31 of MYSQL, which is our test and production version.

Is this correct ?

If so, we will not do any retrograde migration, as this would be not only a backward step but also very time consuming.

So, if the answer is that it is compatible, can anyone indicate how we get it to connect as TCP/IP and Socket attempts have all failed.

If it is not compatible and won't ever work, can anyone suggest the best way to update the database from Excel without extensive SQL scripting as we don't have an SQL specialist in our group and don't really have time to learn to any deep extent. We use Adminer as our database admin tool of choice, which has served us well so far but doesn't really have the capability to do any mass update as far as we can see.

Any help gratefully received.

Options: ReplyQuote

Written By
MySQL for Excel - Compatibility
April 30, 2023 04:15AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.