如何将数据从Microsoft Excel工作表插入/更新到Mysql数据库?

时间:2021-12-15 21:22:40

How to Insert/Update the data from Microsoft Excel sheet to Mysql Database? i wants to insert two fields into a particular table, from excel sheet.

如何将数据从Microsoft Excel工作表插入/更新到Mysql数据库?我想从excel表中将两个字段插入到特定的表中。

For Example: i have two fields in mysql db. (1). Emp id (2). Emp name

例如:我在mysql db中有两个字段。 (1)。 Emp id(2)。 Emp名称

Now i need to insert emp id and emp name from excel sheet. i don't wants to use any programming language, i just need to insert into particular table by using excel data.

现在我需要从excel表中插入emp id和emp名称。我不想使用任何编程语言,我只需要使用excel数据插入特定的表。

can you please suggest any queries

你能否提出任何疑问?

1 个解决方案

#1


Export excel book as .cvs and inport it into mysql

将excel书导出为.cvs并将其导入mysql

#1


Export excel book as .cvs and inport it into mysql

将excel书导出为.cvs并将其导入mysql