ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

Import data MySQL to Excel & Excel to MySQL

•Download as PPTX, PDF•
•
Thooyavan Venkatachalam
Thooyavan Venkatachalam

This document provides steps to import data from MySQL to Excel: 1. Install the MySQL driver and configure an ODBC data source to connect to the MySQL database. 2. In Excel, connect to the ODBC data source and select the MySQL database and table to import data from. 3. The data from the selected MySQL table will then be imported into Excel.

1 of 18
Downloaded 11 times
Import data from Mysql to Excel Presented by, Thooyavan V
Step 1: Download the driver from the website which is given below. First drive(8.0 M). After downloading, install it in your system
Step 2: Go to Control panel-> Administrative Tools-> Select Data source(ODBC). Below dialog box will open.
Step 3: Click Add. Then select below image
• Step 4: Click Finish. Then give the necessary details which is shown below. • In the name, description field give any name. • In Database field, select the database from the drop down menu.
Step 5: Click ok
Step 6: Now Open Excel, In Data field-> select Connection->Select Add->Select Browse for more->select +Connect to New data Source-> Click Open
Step 7:
Step 8: Select the data source as the name which is given earlier(i.e.,excelmysql1)
Step 9: Select any Database name. Here I gave mark database for Example.
Step 10: Click finish
• Step 11: Now In same Excel->Data Tab-> select Connection->Select Existing Connection • Step 12: Here select database table name.
For Example,
Step:13: Click OK.
Step 14:Now the data from the database will get displayed in Access like this
Import data from Excel to Mysql
• In mysql create a database and table with particular fields. • In Excel, give the data alone(Without field name). • Save the excel in .csv (Comma separated) format. • Open Mysql • Use database name;
• Give the Query to import from excel to mysql: • load data infile ‘Give the path of ur .csv file’ into table table_name fields terminated by ‘,’ lines terminated by ‘n’; • Then see the data by the query: select * from table name;

More Related Content

Import data MySQL to Excel & Excel to MySQL

  • 1. Import data from Mysql to Excel Presented by, Thooyavan V
  • 2. Step 1: Download the driver from the website which is given below. First drive(8.0 M). After downloading, install it in your system
  • 3. Step 2: Go to Control panel-> Administrative Tools-> Select Data source(ODBC). Below dialog box will open.
  • 4. Step 3: Click Add. Then select below image
  • 5. • Step 4: Click Finish. Then give the necessary details which is shown below. • In the name, description field give any name. • In Database field, select the database from the drop down menu.
  • 7. Step 6: Now Open Excel, In Data field-> select Connection->Select Add->Select Browse for more->select +Connect to New data Source-> Click Open
  • 9. Step 8: Select the data source as the name which is given earlier(i.e.,excelmysql1)
  • 10. Step 9: Select any Database name. Here I gave mark database for Example.
  • 11. Step 10: Click finish
  • 12. • Step 11: Now In same Excel->Data Tab-> select Connection->Select Existing Connection • Step 12: Here select database table name.
  • 15. Step 14:Now the data from the database will get displayed in Access like this
  • 17. • In mysql create a database and table with particular fields. • In Excel, give the data alone(Without field name). • Save the excel in .csv (Comma separated) format. • Open Mysql • Use database name;
  • 18. • Give the Query to import from excel to mysql: • load data infile ‘Give the path of ur .csv file’ into table table_name fields terminated by ‘,’ lines terminated by ‘n’; • Then see the data by the query: select * from table name;