将数据从excel复制到db [英] copy data from excel to db

问题描述

我在excel表中有名单我想在mysql数据库中添加名单。但是我使用open office for excel。 PLZ帮助我吗？

i have name list in excel sheet i want to add name list in mysql database.but i m using open office for excel. plz help me?

推荐答案

如果您正在寻找工具，请查看：

将Excel数据导出到MySQL [ ^ ]。

或

将Excel2MySQL Excel平移到MySQL [ ^ ]。

If you are looking for a tool then have a look at:
"Export Excel Data into MySQL"[^].
or
"Panofish Excel2MySQL Excel to MySQL"[^].

Sql Server数据库



您绝对可以使用Sql Server Import向导将数据导入新表。当然，您不希望将该表保留在数据库中，因此我建议您导入到新表中，然后在查询管理器中编写脚本以插入到现有表中。您可以添加一行来删除导入向导创建的临时表，作为成功完成脚本的最后一步。

Sql Server Database

You most definitely can use the Sql Server Import wizard to import data into a new table. Of course, you do not wish to leave that table in the database, so my suggesting is that you import into a new table, then script the data in query manager to insert into the existing table. You can add a line to drop the temp table created by the import wizard as the last step upon successful completion of the script.

这篇关于将数据从excel复制到db的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！