ÈçºÎ½«EXCELµ¼Èëµ½ACCESSÖУ¬ÊÖ¶¯/×Ô¶¯ ¶¼¿É
RT~ÇóÖú
¡£¡£ÒýÓà 1£¬Í¨¹ý´úÂë¶ÁÈ¡excelÊý¾Ýµ½dataset C# codeprivate DataSet GetExcelColInfo(string path) { DataSet ds=new DataSet(); FileInfo fileInfo=new FileInfo(path);if (fileInfo.Exists) {string strConn=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ path+";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'";// HDR=YES Ϊ±íµÄµÚÒ»Ðв»×÷ΪÊý¾Ý¶ÁÈë OleDbConnection conn=new OleDbConnection(strConn);try { conn.Open();string sql="select * from [Sheet1$]"; OleDbDataAdapter da=new OleDbDataAdapter(sql, conn); da.Fill(ds); }catch (Exception ex) {throw ex; }finally { conn.Close(); } }return ds; } 2£¬ÔÙ°ÑdatasetµÄÊý¾ÝÑ»·Ð´Èëaccess ÄÜÏêϸµãÂ𣿠µÚ¶þ²½Ò²½ÌÎÒÏ µÚ¶þ²½¾ÍÊǸù¾ÝdatasetµÄÐÐÀ´Ñ»·Ö´ÐÐsql C# code Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺 £¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£® µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
µÚÒ»´Î½Ó´¥CrystalReport ¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó. ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл! ¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ, ÇëÎÊÓÐʲôºÃ°ì·¨Âð? °²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£ ÒýÓà °²×°OFFICE £¬Ñ¡Ôñ°²×° ......
֮ǰÓÃACCESS×öµÄÒ»¸öϵͳ£¬ÏÖÔÚ½«±í¶¼×ªµ½SQLÀȻºóÓÃODBCÁ¬½ÓSQL±í¡£ ÏÖÔÚÓиöÎÊÌâ¾ÍÊÇ£¬ÎÒÆäÖÐÓÐÒ»¸ö±íµÄÊý¾ÝÊÇ´ÓEXCELÀïµ¼ÈëµÄ£¬Èç¹û±íÔÚACCESS±¾µØµ¼ÈëÕý³££¬ÏÖÔÚÓÃÁ´½Ó±íµ½SQL£¬µ¼ÈëʱÌáʾ³É¹¦£¬µ«±íÄÚÎÞÊý ......