Connect to Microsoft Excel through OLEDB

The following script shows an example connection for Microsoft Excel through OLEDB:

Connection=aaDBAccess.GetConnection(

"Provider=Microsoft.Jet.OLEDB 4.0;

Data Source=C:\NameAndAddress.xls;

Extended Properties=Excel 8.0;",

aaDBConnectionType.OleDb);

Note: Microsoft Excel does not support transactions (commit or rollback).