Import data MySQL to Excel & Excel to MySQL

Import data MySQL to Excel & Excel to MySQL

• 1.
  Import data from Mysqlto Excel Presented by, Thooyavan V
• 2.
  Step 1: Downloadthe driver from the website which is given below. First drive(8.0 M). After downloading, install it in your system
• 3.
  Step 2: Goto Control panel-> Administrative Tools-> Select Data source(ODBC). Below dialog box will open.
• 4.
  Step 3: ClickAdd. 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.
• 6.
  Step 5: Clickok
• 7.
  Step 6: NowOpen Excel, In Data field-> select Connection->Select Add->Select Browse for more->select +Connect to New data Source-> Click Open
• 8.
  Step 7:
• 9.
  Step 8: Selectthe data source as the name which is given earlier(i.e.,excelmysql1)
• 10.
  Step 9: Selectany Database name. Here I gave mark database for Example.
• 11.
  Step 10: Clickfinish
• 12.
  • Step 11:Now In same Excel->Data Tab-> select Connection->Select Existing Connection • Step 12: Here select database table name.
• 13.
  For Example,
• 14.
  Step:13: Click OK.
• 15.
  Step 14:Now thedata from the database will get displayed in Access like this
• 16.
  Import data from Excelto Mysql
• 17.
  • In mysqlcreate 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 theQuery 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;