如何解决它“来自外部数据库驱动程序的意外错误（这里是一些符号）” [英] how to solve it "Unexpected error from external database driver(here is some symbol)"

问题描述

以下是将关于（600000）的excel数据传输到sql的代码

Here is code of transferring excel data about(600000) to sql

chkProc = 0;
OleDbConnection oconn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("" + pathss + "") + ";Extended Properties=Excel 12.0;Persist Security Info=False");
OleDbCommand ocmd = new OleDbCommand("select * from [" + sheetss + "$]", oconn);
oconn.Open();
OleDbDataReader odr = ocmd.ExecuteReader();

请帮我解决一下或告诉我如何出口巨额excel数据（最多1000000）到sql ...

Please help me to solve it or tell me how to export huge excel data (upto 1000000) to sql ...

推荐答案

，oconn）;
oconn.Open（）;
OleDbDataReader odr = ocmd.ExecuteReader（）;

", oconn); oconn.Open(); OleDbDataReader odr = ocmd.ExecuteReader();

请帮我解决或告诉我如何导出巨大的Excel数据（高达1000000） ）to sql ...

Please help me to solve it or tell me how to export huge excel data (upto 1000000) to sql ...

没有错误消息显示'这里有一些符号'。发布确切的错误。你也可以尝试分页你的请求，并一次处理XX条记录。 Excel的驱动程序支持TOP和订购？

No error message says 'here is some symbol'. Post the exact error. You could also try paging your request, and handling XX records at a time. Does the driver for Excel support TOP and order by ?

这篇关于如何解决它“来自外部数据库驱动程序的意外错误（这里是一些符号）”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！