A5_ExcelConnString()

Syntax

Connection_String as C = A5_ExcelConnString( Filename as C )

Argument	Description
Connection_String	A connection string for the specified Microsoft Excel file.
Filename	The path and name of a Microsoft Excel spreadsheet.

Description

The A5_ExcelConnString() function returns a connection string for a named Excel file.

Supported By

Alpha Five Version 7 and Above

Limitations

Desktop applications only.

Example

? a5_excelconnstring("c:\customer.xls")

= "Provider=MSDASQL;Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\customer.xls"