如何在mysql DB中导入Excel文件? [英] How import excel file in mysql DB?

问题描述

我有Excel文件(CSV).我只想将excel数据插入mysql DB.

它不是从mysql导出的CSV文件.

我只是由我在MS excel中创建的.

如果有可能...?

谢谢...

Hi,

I have excel file (CSV). I just want to insert the excel data into mysql DB.

It is not a export CSV file from mysql.

I just create by me in MS excel.

If any possibilities...?

Thanks...

推荐答案

有什么可能的...?"

想到两点:
1)编写一些软件的代码以读取CSV文件，如果记录不存在，则将其插入数据库中.您可能必须删除/创建数据库表，并即时计算字段格式-我不知道，我不知道您的情况.
2)使用MySql数据库管理器导入CSV数据.大多数将内置此功能:Google并找到您喜欢的性价比.您可能已经可以访问一个.

"any possibilities...?"

Two spring to mind:
1) Code some software to read the CSV file, and insert records in the database if they do not already exist. You may have to drop / create the database table, and work out the field formats on the fly - I don''t know, I have no idea of your situation.
2) Use a MySql database manager to import the CSV data. Most will have this built in: Google and find one you like the price/performance ratio of. You may have access to one already.

这篇关于如何在mysql DB中导入Excel文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！