<% DIM connxls, connStrxls
Connstrxls = "dbq = d: /newexcel.xls; defaultdir =; driver = {Microsoft Excel Driver (* .xls)};
SET CONNXLS = Server.createObject ("AdoDb.Connection")
Connxls.open Connstrxls
Set Rsxls = Server.createObject ("AdoDb.Recordset")
SQLXLS = "SELECT *" "
%>
Note: Writing and Connection Access is basically the same, different, when calling a worksheet, you cannot use the table name, the work name is added, and "[]" is enclosed.
