Skip to main content

How to Use Connector/ODBC with Microsoft Word, Excel or Access to connect to MySQL

You can use Microsoft Excel, Word to access information from a MySQL database using ODBC. 

Within Microsoft Excel or Word there are facilities to import data from MySQL database. 

See the following steps.
Step-1 : Be sure that your MySQL server is running. 
Step-2 : Create a new worksheet.
Step-3 : From the Data menu, click on 'From other sources' then click on 'Data Connection Wizard', the following window will come : 
Select 'ODBC DSN' and Click on 'Next' 
Step-4 : From ODBC data sources select 'MySQL' and click on 'Next' 
Step-5 : Now select databases and tables.
Step-6 : Let select database and table and click 'Next'. 
Step-7 : Input a name and description for your new Data Connection, and press 'Finish' to save. 
Step-8 : Select how you want to view this data in your workbook (e.g. Table, PivotTable Report etc). 



Post a Comment

Popular posts from this blog

How to reset password of Jenkins

Reset password of JenkinsPrefer way, No securities were harmedSee also:
What is Jenkins' initial admin password

To reset it without disabling security if you're using matrix permissions (probably easily adaptable to other login methods): In config.xml, set disableSignup to false.Restart Jenkins.Go to the Jenkins web page and sign up with a new user.In config.xml, duplicate one of the <permission>hudson.model.Hudson.Administer:username</permission> lines and replace username with the new user.If it's a private server, set disableSignup back to true in config.xml.Restart Jenkins.Go to the Jenkins web page and log in as the new user.Reset the password of the original user.Log in as the original user. Optional cleanup: Delete the new user.Delete the temporary <permission> line in config.xml.
Alternative way:
ssh to the server, disable authentication, set the password via the Jenkins Web UI, then enable authentication.

How to Remove / Hide "Powered by Blogger" (Attribution Gadget)

Settings -> Template -> Edit HTML -> Jump to widget: choose Attribution1

Change it to:

<b:widget id='Attribution1' locked='false' mobile='no' title='' type='Attribution'/>

Go to Layout, remove Attribution1 widget.

To hide: Template -> Customize ->  Advanced -> Add CSS - Paste the following code  -> Apply to Blog:
#Attribution1 { display: none!important; }