Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

The method of importing excel into phpmyadmin

2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

This article is about how to import excel into phpmyadmin. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1. The first step is to get an excel table with a lot of data that we need to import.

2. Delete the first line "admission card number" and "XXX". Keep only the part of the data we need.

3. Click "File"-"Save as", select the type "CSV (comma separated) (* .csv)", and save the excel table as an csv document. It would be nice to be "yes" no matter what the hint is in the middle.

4. Key points! Slyar.csv saved as can be opened with a text editor such as notepad or Editplus. Let's open it and have a look.

You can see that csv documents are actually txt (that is, you can use your own txt and change the suffix name), but separate the fields with ",". Since it is an txt document, it involves the issue of file encoding! The default saved file encoding is ANSI, and if your database (datasheet) uses UTF-8 encoding, be sure to save the csv file in UTF-8 format!

5. Go to phpMyAdmin to create a table and create a new field with the field name associated with the excel field you want to import in the same order. It's too easy to take screenshots.

6. Open the table you created in phpMyAdmin and click "Import" at the top.

7. "Import file format" Select the second "CSV uses LOAD DATA".

8. "File to Import" Select the csv file you just saved as.

9. The "field delimiter" is changed to ",", which means that excel is saved as the default choice of "(comma delimited)". You are free to choose the delimiter, usually when there is "," in your excel table data.

10. "Field name" is an advanced application. The field name here is the field name in your data table. It represents the field you want to fill in, separated by ",". If it is empty, it means that it is all filled, and it is filled in order, and the excess data is not needed.

10. If there is no problem with the inspection, you can press "execute".

11. "Import succeeded and 1 query was executed". If you see this, you are successful. If the import is not successful, please redo it carefully against this article from beginning to end.

Thank you for reading! This is the end of this article on "how to import excel into phpmyadmin". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report