How to Bulk Import Excel data into a database (MYSQL)--Tools phpMyAdmin

Source: Internet
Author: User
Tags phpmyadmin

Before because data storage uses Excel to save all the data, after preliminary data filtering, the amount of data is nearly 4,000. A single entry into the database is obviously not feasible. Here are the steps I'm working on:

1. Keep only the data part of Excel, remove the specific description of the first line

2. Save the file as (. csv) format

3. Save the file that you just saved in CSV format with TXT open again as

Attention! The code changes to UTF-8 this step must have, otherwise the import is very likely to appear garbled.

4. In phpMyAdmin, create a table in data order, new field, field name associated with the Excel table field you want to import, and in the same order.

5. Click "Import" and "Select File" (CSV file just changed)

6. Follow the changes to "format" and "Field delimiter" (Must be Comma ",")

7. Click Execute

Data can be successfully imported spicy ~

If the data appears garbled,

Please recall

(1) Is it successful to change UTF-8?

(2) is the database character set UTF-8?

(3) Does setting the table's properties correspond to UTF-8?

(4) Sorting rules must remember to change, because the default is Latin what what?

I've met all these problems ┑ ( ̄д ̄) ┍

(5) Help network/Great God ~

How to Bulk Import Excel data into a database (MYSQL)--Tools phpMyAdmin

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.