Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎ½«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/

-


Ïà¹ØÎÊ´ð£º

ASP+ACCESSÊä³öÎÊÌâ - Web ¿ª·¢ / ASP

ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......

ÈçºÎÐÞ¸ÄACCESSϵͳ±í

ÈçºÎÐÞ¸Ämsysobjects±íÖеÄÊý¾ÝÄØ£¿Ð»Ð»
ɶ¶¼Ã»ÓÐ,Òâ˼²»Ã÷È·,ÔÙÏêϸµã°É

²»Òª¸ÄsysobjectsÀïµÄ¶«Î÷¡£
ÓÃÆäËü·½·¨¸Ä£¬±íÃû»òÆäËû¡£

ÒªÔÚACCESS»·¾³ÏÂÅäÖÃȨÏÞ£¬²ÅÄÜ·ÃÎÊϵͳ±í...

лл´ó¼Ò¡£
ÊÇÕâÑù£¬¿´ ......

ÈçºÎ½«accessÀïÃæµÄ¸½¼þ±£´æµ½´ÅÅÌÉÏÄØ

Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit

ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......

ÇóÖú ¹ØÓÚASP access excelµ¼ÈëºÍµ¼³ö

ÍøÉÏÕÒµ½µÄ¶¼ÊÇasp.net
ÓÐûÓÐaspµÄµ¼Èëµ¼³öÍêÕû´úÂë

ÒýÓÃ
CSDNÉÏÄãËÑËÑ ¾ÍÓкܶà Õâ¸öÊǵ¼³öhttp://topic.csdn.net/u/20100104/10/fd959988-1ea6-46eb-9fe3-c4fe0e5ba234.html?8966
²»ÊÇµÄ ÎÒÏÖÔÚÄܵ¼ÈëºÍµ¼³ ......

tomcatÁ¬½ÓAccessÊý¾Ý¿âÎÊÌâ¡£ - Java / Web ¿ª·¢

¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 - 
------------------------------------------------------------------------------- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ