Avatar of Patricia Timm
Patricia Timm
 asked on

download mysql for excel on excel spreadsheet for 64bit windows 1o to export excel to mysql tables

Want to create an icon (the connection icon comes with download) on excel spreadsheet for mysql for excel so I can export the excel spreadsheet into mysql tables. I want to click on icon and then choose my connection and then tables show up. I went to https://dev.mysql.com/downloads/windows/excel/ to download the mysql installer but only have choices for Windows (x86, 32-bit), MSI Installer and I have 64-bit windows 10. Any ideas on how I can download this so I can connect to mysql from the excel spreadsheet
Microsoft ExcelMySQL ServerMicrosoft Office

Avatar of undefined
Last Comment
Patricia Timm

8/22/2022 - Mon
als315

Look at info page (tab marked "i"):

Note: MySQL Installer is 32 bit, but will install both 32 bit and 64 bit binaries.

Patricia Timm

ASKER
When I download nothing happens. I dont see on any excel spreadsheets under data. I tried restarting and still dont see. These are my steps
o https://dev.mysql.com/downloads/windows/excel/ then I choose No thanks, just start my download. NEXT INSTALL ANYWAY then YEs allow this app to make changes to my device. Then I get message states welcome back thanks for downloading and installing an updated mysql installer for windows bundle... I then went thru the wizard for the upgrades. After I finish.... I would think okay done with download. Restart computer and still do not see under data in excel. Ithought maybe because I have 64 bit and download is for 32 but that doesnt matter based on previous post. Thanks again. Not sure what I am doing wrong
als315

If all is installed without errors, you should see additional option in Data tab on Excel ribbon:

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Patricia Timm

ASKER
I do not see this in the ribbon. I do not get errors when installing. I am not sure what I am doing wrong. Is there a way to check and make sure that this was downloaded properly?
Patricia Timm

ASKER
I do not have in the data tab in excel after downloading https://dev.mysql.com/downloads/windows/excel/
Patricia Timm

ASKER
under settings and applications would it be mysql router? I have several mysql apps.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Patricia Timm

ASKER
mysql workbench is working and I can connect
ASKER CERTIFIED SOLUTION
als315

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Patricia Timm

ASKER
Thank you.