Excel and Access 97 2003¡¢2007µÄÁ¬½Ó´®
ÏÂÎçÔÚExcelµ¼ÈëSQLʱ£¬·¢ÏÖÔÁ¬½ÓExcelµÄÊý¾ÝÁ¬½Ó´®¹ýʱÔì³ÉеÄExcel¸ñʽ*.xlsxÎÞ·¨Ê¶±ð¡£
°ÑеÄÁ¬½Ó´®Ìæ»»~
·Ö±ð²âÊÔ03/07µÄExcelÎļþ¾ù¿Éͨ¹ý~
Office 97-2003°æ±¾
Excel: Provider= Microsoft.Jet.OLEDB.4.0;Data Source=ÎļþλÖÃ;Extended Properties=Excel 8.0;
Access: Provider= Microsoft.Jet.OLEDB.4.0;Data Source=ÎļþλÖÃ;Jet OLEDB:Database Password=ÃÜÂë;
Office 2007°æ±¾
Excel: Provider= Microsoft.Ace.OleDB.12.0;Data Source=ÎļþλÖÃ;Extended Properties=Excel 12.0;
Access: Provider= Microsoft.Ace.OleDB.12.0;Data Source=ÎļþλÖÃ;Jet OLEDB:Database Password=ÃÜÂë;
Ïà¹ØÎĵµ£º
´´½¨»ùÓÚ¶Ô»°¿òµÄÓ¦ÓóÌÐòADO,Ïò¶Ô»°¿òÖÐÌí¼ÓÒ»¸öÁбíÊÓͼ¿Ø¼þ£¬²¢ÎªÆäÌí¼Ó±äÁ¿m_Grid
µÚÒ»²½£ºADO¶ÔÏóµÄµ¼Èë
ÔÚStdAfx.hÍ·ÎļþÖУº
// stdafx.h : include file for standard system include files,
// or project specific include files that are used frequently, bu
// are ......
×î³£¼ûµÄÊý¾ÝÀàÐÍÓ³ÉäµÄÁбí
ϱíÁгöÁËÔÚ Microsoft Access ºÍÈçºÎÕâЩÊý¾ÝÀàÐÍÓëÏà¹Ø Microsoft.net ¿ò¼ÜÊý¾ÝÀàÐÍ£¬²¢ OleDbType ö¾ÙÖÐʹÓÃ×î³£¼ûµÄÊý¾ÝÀàÐÍ¡£
ÊÕÆð¸Ã±í¸ñÕ¹¿ª¸Ã±í¸ñ
·ÃÎÊÀàÐÍÃû³Æ
Êý¾Ý¿âÊý¾ÝÀàÐÍ
OLE DB ÀàÐÍ
.NET ¿ò¼ÜÀàÐÍ
³ÉÔ±Ãû³Æ
Îı¾
VarWChar
DBTYPE_WSTR
System.String
OleDbType.V ......
¸ù¾Ý±í´ïʽµÄÖµ£¬À´·µ»ØÁ½²¿·ÖÖеÄÆäÖÐÒ»¸ö¡£
Óï·¨
IIf(expr, truepart, falsepart)
IIf º¯ÊýµÄÓï·¨º¬ÓÐÏÂÃæÕâЩÃüÃû²ÎÊý£º
²¿·Ö ÃèÊö
expr ±Ø ......
½â¾ö°ì·¨£º
´Ó Windows µÄ“¿ªÊ¼”²Ëµ¥£¬Ö¸Ïò“³ÌÐò”¡¢ “Visual Studio .NET 2003”¡¢“Visual Studio .NET ¹¤¾ß”£¬È»ºóÑ¡Ôñ“Visual Studio .NET ÃüÁî Ìáʾ”¡£ÔÚ´°¿Ú´ò¿ªºó£¬¼üÈë aspnet_regiis /i¼´¿É¡£
²»¿ÉÐеķ½°¸£º
1¡¢ÖØÆôµçÄÔ¡£
2¡¢É¾³ý»º´æ¡£
3¡¢ÖØÐ ......