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