如果你是用
Microsoft Jet 4.0 Provider Properties
在Extended Properties 的設定如下,可以任何格式
Extended Properties Property Settings
The following table lists the Extended Properties property values to use for the data sources supported by the Jet database engine.
Table 14. Extended Properties property values
Data Source Extended Properties Property value
dBASE dBASE III
dBASE IV
dBASE 5.0
soft Excel Excel 3.0
Excel 4.0
Excel 5.0
Excel 8.0
FoxPro FoxPro tables are accessed by using the Microsoft FoxPro ODBC driver.
Lotus Lotus WK1
Lotus WK3
Lotus WK4
ODBC ODBC
Paradox Paradox 3.x
Paradox 4.x
Paradox 5.x
Paradox 7.x HTML HTML Import
Microsoft Exchange Exchange 4.03
Text Text
1 The Excel 5.0 source database type string is used to specify both Microsoft Excel 5.0 and 7.0 workbooks.
2 The Excel 8.0 source database type string is used to specify both Microsoft Excel 8.0 and 9.0 workbooks.
3 The Exchange 4.0 source database type string is used to specify Microsoft Exchange 4.0, 5.0, and Outlook folders and address books.
微軟官方參考資料:
http://msdn.microsoft.com/library/defau ... topic4.asp
ado connection 參考資料:
http://www.able-consulting.com/ADO_Conn.htm
追加一篇微軟 SQLConfigDataSource
http://msdn.microsoft.com/library/defau ... sdk_59.asp
[轉貼]ODBC或ado connectionstring 設定
[轉貼]ODBC或ado connectionstring 設定
多多留言, 整理文章, 把經驗累積下來.....