MSSQL Óë EXCEL»¥²Ù×÷
SQL SERVER ºÍEXCELµÄÊý¾Ýµ¼Èëµ¼³ö
1¡¢ÔÚSQL SERVERÀï²éѯExcelÊý¾Ý:
-- ======================================================
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\book1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]
ÏÂÃæÊǸö²éѯµÄʾÀý£¬Ëüͨ¹ýÓÃÓÚ Jet µÄ OLE DB Ìṩ³ÌÐò²éѯ Excel µç×Ó±í¸ñ¡£
SELECT *
from OpenDataSource ( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions
-------------------------------------------------------------------------------------------------
2¡¢½«ExcelµÄÊý¾Ýµ¼ÈëSQL server :
-- ======================================================
SELECT * into newtable
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\book1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]
ʵÀý:
SELECT * into newtable
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions
-------------------------------------------------------------------------------------------------
3¡¢½«SQL SERVERÖвéѯµ½µÄÊý¾Ýµ¼³ÉÒ»¸öExcelÎļþ
-- ======================================================
T-SQL´úÂ룺
EXEC master..xp_cmdshell 'bcp ¿âÃû.dbo.±íÃûout c:\Temp.xls -c -q -S"servername" -U"sa" -P""'
²ÎÊý£ºS ÊÇSQL·þÎñÆ÷Ãû£»UÊÇÓû§£»PÊÇÃÜÂë
˵Ã÷£º»¹¿ÉÒÔµ¼³öÎı¾ÎļþµÈ¶àÖÖ¸ñʽ
ʵÀý:EXEC master..xp_cmdshell 'bcp saletesttmp.dbo.CusAccount out c:\temp1.xls -c -q -S"pmserver" -U"sa" -P"sa"'
EXEC master..xp_cmdshell 'bcp "SELECT au_fname, au_lname from pubs..authors ORDER BY au_lname" queryout C:\ authors.xls -c -Sservername -Usa -Ppassword'
ÔÚVB6ÖÐÓ¦ÓÃADOµ¼³öEXCELÎļþ´úÂ룺
Dim cn As New ADODB.Connection
cn.open "Driver={SQL Server};Server=WEBSVR;DataBase=WebMis;UID=sa;WD=123;"
cn.execute "master..xp_cmdshell 'bcp "SELECT col1, col2 from ¿âÃû.dbo.±íÃû" queryout E:\DT.xls -c
Ïà¹ØÎĵµ£º
ORACLE
CREATE OR REPLACE FUNCTION SETSTATE(OLDVALUE VARCHAR2, POS NUMBER, SVALUE VARCHAR2)
RETURN VARCHAR2
IS
RETURN_VALUE VARCHAR2 (20);
LEN NUMBER(8);
I NUMBER(8);
TEMP_VALUE VARCHAR2(1);
BEGIN
LEN := LENGTH(OLDVALUE);
IF POS > ......
ÖÆ×÷ÁËÒ»¸öDTS°ü£¬Äܹ»¿ª·¢»·¾³»òÕßÃüÁîÐÐÏÂÕýÈ·µÄÖ´ÐУ¬µ«ÔÚͨ¹ýAgent À´Ö´ÐеÄʱºò×ÜÊDZ¨´í£º
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step DTSRun OnError: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step, Error = ......
Õâ¶Îʱ¼ä¿´Á˹ØÓÚÔÚSQL server ÖÐͨ¹ýÈÕÖ¾ºÍʱ¼äµãÀ´»Ö¸´Êý¾Ý¡£Ò²¿´ÁËһЩÍøÉϵÄÀý×Ó£¬¿´ÈçºÎͨ¹ýÈÕÖ¾À´»Ö¸´Êý¾Ý¡£
Ç°ÌáÌõ¼þ£º
Êý¾Ý¿âµÄ¹ÊÕϻָ´¸ÄΪ·Ç¼òµ¥Ä£Ê½£¬È¥µô×Ô¶¯¹Ø±ÕºÍ×Ô¶¯ÊÕËõÁ½¸öÑ¡Ïî
&nbs ......
PHP¶ÁÈ¡MYSQLÊý¾Ý¿â»òMSSQLÊý¾Ý¿âʱ£¬ÓÐʱ³öÏÖÂÒÂ룬ÕâÊÇPHP.iniÖÐÅäÖúÍ.phpÒ³Ãæ±àÂë²»Ò»ÖÂÒýÆðµÄ¡£
½â¾ö°ì·¨£º
1¡¢Ê×ÏÈ£¬½«PHP.iniÖÐÉèÖÃΪdefault_charset = "gb2312"£¬È»ºóÖØÆôApache¡£
Õâʱ´ÓÊý¾Ý¿âÖÐÌáÈ¡µÄ½á¹û¼¯¿ÉÒÔÕý³£ÏÔʾÖÐÎÄÁË£¬µ«.phpÒ³ÃæÖеÄÁÐÃûÒ²ÓпÉÄÜÏÔʾÂÒÂëÁË¡£ÕâÑù½â¾ö£¬
2¡¢È»ºó£¬PH ......
ÈçͼËùʾ£¬ÔÚ°²È«ÐÔ-µÇ½Àï¿ÉÒÔ¿´µ½ÓÒ±ßÁбíÀïµÄÓû§£¬Ñ¡ÖÐÓû§ÓÒ¼ü-ÊôÐÔ¿ÉÒÔ¸ü¸ÄÓû§ÃÜÂ룬¼°Êý¾Ý¿â½ÇÉ«µÈ¡£
²é¿´Óû§Ãû£¬¼°ÃÜÂëÊÇ·ñÕýÈ·£¬¿ÉÒÔµ¥¶ÀµÇ½ ²éѯ·ÖÎöÆ÷
Èç¹ûÄܵǽ˵Ã÷ÉèÖÃÕýÈ·£¬ÔÚmssql´î½¨µÄasp cmsÀï¾³£ÒªÓõ½Óû§Ãû£¬ÃÜÂë¡£
ÏÖÔÚ¿´Ã¿¸öÊý¾ÝÏÂÃæµÄÓû§Ñ¡ÏÈçͼ
Ñ¡ÖÐÒ»¸öÒ»¸öÊý¾Ý¿â£¬»òÏÂÃæµÄÓû§Ñ ......