Heidisql Importing Excel data

Source: Internet
Author: User
Tags heidisql

A preface

Original source: http://blog.csdn.net/qq_27727681/article/details/53944744

Two-effect Demo:

More than 2000 data, successfully imported successful.

Three implementation methods:

1 Modifying an Excel file

This is the data and cannot be imported directly.

You must add a column ID column and drag to generate the sequence number. Avoid self-destructive data from the ID column in the database.

2 Generating a CSV file in Excel

(note) The name cannot be a Chinese character. Otherwise, the import will prompt that the file does not exist. Save the prompt, and click Yes directly.

3 Creating a new table in Heidisql

(note) field names and order, to correspond to data one by one in Excel, several fields to build several fields.

4 Importing CSV files in Heidisql

5 Modifying Import parameters

A total of 4 places to note:

1 ignore the number of rows, according to the data in Excel, which do not need, to select

2 Comma separated. When you generate a CSV file, the hints are comma-delimited, separated by columns and columns, and fields in the database. If the heidisql default is a semicolon, you want to modify it manually. Otherwise, only the first column can be generated.

3 data conflicts, whether updated, see your database requirements

4 You can choose to insert data fields. Fields can be many, but not less, and fewer will prompt for an unsuccessful insertion.

Finally, click to import, the lovely thousands of data finally came into the accurate.

In the future can be bold to write data in Excel, will be or Excel operation easy.

Heidisql Importing Excel data

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.