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

This article mainly introduces the method of importing Excel data into navicat in batches, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Open the Navicat on your computer and click "Connect" in the upper left corner.

Select the database type.

Fill in the relevant information.

Once created, the existing database name is displayed.

Select the specified database name, right-click, and select Import Wizard.

Select Excel as the file type.

Select the file you want to import from your computer.

Select which page of Excel.

Then fill in some relevant information.

Determine which columns to import, and sometimes you may not need to import all the columns in Excel into the database.

Then click start, and when it is displayed as Finished, the import is successful.

Then you can see that there is the imported database table here, and the content displayed is also the data in Excel.

Thank you for reading this article carefully. I hope it will be helpful for everyone to share Excel data such as importing navicat in batches. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.