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

[ת]C#.net±à³Ì´´½¨ Access ÎļþºÍ Excel Îļþ

һЩϵͳ¿ÉÄÜÐèÇó°ÑÊý¾Ýµ¼³öµ½Access»òÕßExcelÎļþ¸ñʽ£¬ÒÔ·½±ãµÄ´«µÝÊý¾Ý¡¢´òÓ¡µÈ¡£
Excel Îļþ»òÕß AccessÕâÁ½ÖÖÐèÒªµ¼³öµÄÎļþ¿ÉÄܲ¢²»ÊÇÊÂÏȾʹæÔڵģ¬Õâ¾ÍÐèÒªÎÒÃÇ×Ô¼º±à³ÌÉú³ÉËûÃÇ£¬ÏÂÃæÕûÀíÒ»ÏÂÉú³ÉÕâÁ½¸öÎļþµÄһЩ·½·¨£¬Ö»ÂÞÁÐ×î³£Óõġ£²¢²»È«¡£
Ò»¡¢Ê×ÏÈÉú³ÉExcelÎļþ¡£
    ·½°¸Ò»¡¢Èç¹ûÓÃExcel±£´æµÄÖ»ÊǶþάÊý¾Ý£¬Ò²¾ÍÊǰÑËûµ±Êý¾Ý¿âµÄÀ´Óá£
×î¼òµ¥£¬Äã²»ÓÃÒýÓÃÈκζîÍâ×é¼þ£¬Ö»ÐèÒªÓà OLEDB ¾Í¿ÉÒÔÍê³É´´½¨ExcelÎļþ¡£ ·¶Àý´úÂëÈçÏ¡£
using System.Data.OleDb;
public static void CreateExcelFile2()
  {
   string OLEDBConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\aa2.xls;";  
   OLEDBConnStr +=   " Extended Properties=Excel 8.0;";
   string strCreateTableSQL = @" CREATE TABLE ";
   strCreateTableSQL += @" ²âÊÔ±í ";
   strCreateTableSQL += @" ( ";
   strCreateTableSQL += @" ID INTEGER, ";
   strCreateTableSQL += @" UserID INTEGER, ";
   strCreateTableSQL += @" UserIP VARCHAR , ";
   strCreateTableSQL += @" PostTime DATETIME , ";
   strCreateTableSQL += @" fromParm VARCHAR  ";
   strCreateTableSQL += @" ) ";
   OleDbConnection oConn = new OleDbConnection();
  
   oConn.ConnectionString = OLEDBConnStr;
   OleDbCommand oCreateComm = new OleDbCommand();
   oCreateComm.Connection = oConn;
   oCreateComm.CommandText = strCreateTableSQL;
   oConn.Open();
   oCreateComm.ExecuteNonQuery();
   oConn.Close();
}
using System.Data.OleDb;
public static void CreateExcelFile2()
  {
   string OLEDBConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\aa2.xls;";  
   OLEDBConnStr +=   " Extended Properties=Excel 8.0;";
   string strCreateTableSQL = @" CREATE TABLE ";
   strCreateTableSQL += @" ²âÊÔ±í ";
   strCreateTableSQL += @" (


Ïà¹ØÎĵµ£º

PBÖÐÁ¬½ÓAccessÊý¾Ý¿âµÄÈýÖÖ·½·¨

PBÖÐÁ¬½ÓAccessÊý¾Ý¿âµÄÈýÖÖ·½·¨
·½Ê½Ò»£º
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='driver=Microsoft Access Driver (*.mdb);DBQ=c:\foodmart.mdb'"
CONNECT;
IF SQLCA.SQLCode <> 0 THEN
MessageBo ......

asp.netÁ´½ÓAccessÊý¾Ý¿â×Ö·û´®ÕýÈ··½·¨

ÔÚweb  configÖР ×÷ÈçÏÂÅäÖãº
<connectionStrings>
    <add name="ydycon" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=|DataDirectory|ydy.mdb" providerName="System.Data.OleDb"/>
 
  </connectionStrings>
ÔÚ.netÎļþÖÐÓ¦ÓÃÁ´½Ó ......

EA2A(Excel/Access to Access)

Èí¼þÃû³Æ: EA2A(Excel/Access to Access)
Èí¼þ°æ±¾: beta2
ÊÚȨÐÎʽ: Ãâ·ÑÈí¼þ
ÔËÐÐÆ½Ì¨: Win9x/Me/NT/2000/XP/2003
Êý¾Ý¿âÉý¼¶ºóÔ­ÓбíÖÐ×ֶλáÔö¼Ó£¬´ËʱÎÒÃǾÍÐèÒªµ¼Èë£¨Ç¨ÒÆ£©Êý¾Ý£¬´Ë³ÌÐòΪʵÏִ˹¦Äܶø±àд¡£
ͨ³£Èí¼þÉý¼¶ºó£¬Êý¾Ý¿âÒ²»áÓÐËù¸Ä±ä£¬´Ëʱ¾ÍÐèÒª¶Ô¿Í»§Ê¹ÓõÄÊý¾Ý¿â½øÐÐÉý¼¶¡£Éý¼¶¿Í»§Êý¾Ý¿âµÄ·½Ê½Ó ......

C#: ÌáÈ¡ÍøÒ³ÖеÄjavascript´úÂë

public static void Main()
        {
            WebRequest req = WebRequest.Create("http://blog.csdn.net/xiaofengsheng");
            try
  & ......

Javaµ÷ÓÃC#µÄWebServiceʵÀýÈý(ʵ¼ÊÓ¦ÓÃ)

/*
   ±¾¶Î´úÂëÔÚ¹«Ë¾ÏîÄ¿ÖÐʵ¼ÊÔ¶³Ìµ÷ÓõÚÈý·½¹«Ë¾ÌṩµÄC#¿ª·¢WebServiceµÄʾÀý
*/
/**
  * µÇ¼ÓÎÏ·
  *
  * @param paramPN
  * @param paramTerraceID
  * @param paramSvrID
  */
 private String loginGame(String paramPN, HttpServletRequest req){
&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ