将excel数据导入mysql [英] Import excel data into mysql

问题描述

嗨......

你能告诉我吗，

如何通过编程方式将excel数据导入mysql在asp.net中是可行的！

解决方案

首先从excel读取数据并将其放入数据集中，然后您必须将该数据集中的数据插入表格。

请查看以下链接：

http://forums.asp.net/t/1608097.aspx/1 [ ^ ]

http://social.msdn.microsoft。 com / forums / zh-CN / csharpgeneral / thread / ef11a193-54f3-407b-9374-9f5770fd9fd7 [ ^ ]

http://www.dreamincode .net / code / snippet1413.htm [ ^ ]

参考文章

使用ASP中的C＃将数据从excel导入SQL服务器。 NET [ ^ ]

http://www.techrepublic.com/blog/datacenter/how-to-import-an-excel-file-into-sql-server-2005 -using-integration-services / 205 [ ^ ]

嗨...

它可能对你有帮助。

在mysql命令promt窗口中写入cmmd。

 将数据本地infile'文件路径'加载到 表 databasename字段终止 by '，'随附 by ' '以'\ n'结尾的行;  

这样也可以通过命令将文件插入到数据库中。

谢谢你。

Hi...
Can u tel me,
How to import excel data into mysql by programmatically is posible in asp.net!

解决方案

First read data from excel and put it in a dataset then you have to insert data from that dataset to table.
Take a look at following links:
http://forums.asp.net/t/1608097.aspx/1[^]
http://social.msdn.microsoft.com/forums/en-US/csharpgeneral/thread/ef11a193-54f3-407b-9374-9f5770fd9fd7[^]
http://www.dreamincode.net/code/snippet1413.htm[^]

Refer article
Import Data from excel to SQL server using C# in ASP. NET[^]
http://www.techrepublic.com/blog/datacenter/how-to-import-an-excel-file-into-sql-server-2005-using-integration-services/205[^]

Hi...
its may helpful to u.
write blow cmmd in mysql command promt window.

Load data local infile ‘file path’ into table databasename fields terminated by ‘,’ enclosed by ‘"’ lines terminated by ‘\n’;

this way also excel file insert into database through command.
thank u.

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