关闭

Microsoft Access Database Engine 2010 Redistributable

764人阅读 评论(0) 收藏 举报
  1. If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.
  2. If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”

    If you are connecting to Microsoft Office Excel data, add the appropriate Extended Properties of the OLEDB connection string based on the Excel file type:

    File Type (extension)                                             Extended Properties
    ---------------------------------------------------------------------------------------------
    Excel 97-2003 Workbook (.xls)                                  "Excel 8.0"
    Excel 2007-2010 Workbook (.xlsx)                             "Excel 12.0 Xml"
    Excel 2007-2010 Macro-enabled workbook (.xlsm)      "Excel 12.0 Macro"
    Excel 2007-2010 Non-XML binary workbook (.xlsb)      "Excel 12.0"

  3. If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
  4. If you are an application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”
0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:183336次
    • 积分:3391
    • 等级:
    • 排名:第9935名
    • 原创:154篇
    • 转载:0篇
    • 译文:3篇
    • 评论:30条
    文章分类
    最新评论