Using Excel Spreadsheet

MyEspinda! .Customers Login Here

Documentation

Matrix Stats

Overview

Using MatrixStats

Administration Menu

Scripting and Databases

Sending mail using a script

Scripting JMail with ASP

Scripting JMail with Perl

Scripting CDONTS with ASP

Scripting Access with Perl

Scripting Access with ASP

DSNLESS database usage

Access Database Problems

Using Excel Spreadsheet

Redirection Scripts

Ready to use Hit Counter

Ready to use Form2Mail

How do I connect to an Excel Spreadsheet ?

Many people have difficulty connecting through ODBC to an Excel Spreadsheet. The following connection string uses OLEDB to connect to a speadsheet in the private directory of a site:

strconn = "DRIVER=Microsoft Excel Driver ({use star character}.xls);
UID=admin;
UserCommitSync=Yes;
Threads=3;
SafeTransactions=0;
ReadOnly=1;
PageTimeout=5;
MaxScanRows=8;
MaxBufferSize=2048;
FIL=excel 8.0;
DriverId=790;
DefaultDir=" + Server.MapPath("..\..\private") + ";
DBQ=" + Server.MapPath("..\..\private\test.xls") + ";"

Notes:
1. Server.MapPath is used to get the absolute path.
2. No ODBC link needs to be created. This is pure code based database connectivity.
3. You should only read from Excel Spreadsheets through this type od connection.