将具有6500行的Excel上载到MSSQL数据库表中 [英] Upload Excel having 6500 rows into MSSQL database table

问题描述

我想将excel文件上传到数据库表功能，但excel文件应该包含65K行和40列。

所以请告诉我执行此功能的最佳/最佳方式。

Hi,

I want to implement the excel file upload into database table functionality , but excel file should contain 65K Rows & 40 columns.
so pls tell me the best/optimal way to do this functionality.

推荐答案

我认为使用应该使用百万而不是十万。 :)



我建议你看一下SQL Server Express。一百万不多说，一个领域（一列）一百万是一回事，一百万就有100个领域是另一回事。你应该能够直接连接到Excel。



我不推荐excel vba。我认为限制是excel中的百万记录（2013-1亿行）

I think use should use million instead of lakhs. :)

I suggest you look at SQL Server Express. A million does not say much, a million with one field (column) is one thing, a million with 100 fields is another. You should be able to connect directly to Excel.

I would not recommend excel vba. I think the limit is million record in excel (2013- 100 million rows)

http://hemgoogali.wordpress.com/2012/10/19/import-excel-to-sqlserver2005/ [ ^ ]





请按照此步骤操作。打开快照。它会帮助你，但这是手动工作。

http://hemgoogali.wordpress.com/2012/10/19/import-excel-to-sqlserver2005/[^]


Please follow this step. Open the snapshots. It will help you but this is manually works.

如果新版本的excel支持超过65000行导出，那么你可以

If new version of excel support more than 65000 rows to export then you can

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\testing.xlsx;Extended Properties='Excel 12.0 Xml;HDR=Yes;IMEX=1;'");
        OleDbCommand cmd = new OleDbCommand("select * from [Sheet1

这篇关于将具有6500行的Excel上载到MSSQL数据库表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！