ASE :(?)
Conn open "driver = {microsoft dbase driver}; sourceType = db; sourceb =" & server.mappath ("directory name")
Recordset.open Strsql, CONN, 2, 2
Foxbase:
Conn Open "driver = {Microsoft Visual FoxPro Driver}; SourceType = DBF; SourceDb =" & Server.mAppath ("Directory Name")
Recordset.open DBF file name or SELECT statement, conn, 2, 2
Conn open "driver = {Microsoft Visual FoxPro Driver}; SourceType = DBC; SOURCEDB =" & Server.mAppath ("DBC Database File Name")
Recordset.open DBF file name or SELECT statement, conn, 2, 2
Excel:
Conn open "driver = {Microsoft Excel Driver (* .xls)}; dbq =" & server.mappath ("XLS file name")
Recordset.open "SELECT *" & Sheet & "$], conn, 2, 2
Note: Use DBF, DBC, Excel database, below to note: Excel database can only read, add record, modify record, but cannot delete records;
DBF, DBC can read records, add records, delete records, modify records, but when increasing records, any field value cannot be empty, thereby
It can be seen that the limitations are large, so use the MDB or SQL database as much as possible.
