[求助]：我用的是R14要如何才能与ACCSEE传递数据

jackma

前两天有朋友让帮忙在R14下开发与ACCESS接口的文挡分类

请大虾指点迷经

lsjjm

REFER TO:
www.acadx.com


Create Connection String for MS-Access or MS-SQL Server Databases

;;;******************************************************************
;;; Connect to MS-Access Database using ODBC (no DSN required)
;;; Ex. (DbConnect_MSAccess1 "d:/dbfiles/products.mdb")
;;;******************************************************************

(defun DbConnect_MSAccess1 (dbFile)
  (strcat
    "Provider=MSDASQL;"
    "Driver={Microsoft Access Driver (*.mdb)};"
    "DBQ=" dbFile
  )
)

;;;******************************************************************
;;; Connect to MS-Access Database using JET 3.51
;;; Ex. (DbConnect_MSAccess2 "d:/dbfiles/products.mdb")
;;;******************************************************************

(defun DbConnect_MSAccess2 (dbFile)
  (strcat
    "Provider=Microsoft.Jet.OLEDB.3.51;"
    "Data Source=" dbFile
  )
)