Connecting to an Excel File

[Mahmood_M]

Hi
I want to connect to an Excel file
I have set Provider property of UniConnection to "ODBC" and Server property to "Excel Files" but there is no option to set Excel File Address

How can I Connect to an Excel File with UniDAC ? is it possible ?

I can do it with ADO but I want to use UniDAC

thanks ...

[Mahmood_M]

Any help ?
Is it possible ? or not ?

thanks

[AlexP]

Hello,

You should download and install the ODBC driver for Excel from the official Microsoft website: https://www.microsoft.com/en-us/downloa ... n&id=13255 . Then create a DSN in ODBC Data Source Administrator, select the ODBC provider from the Server drop-down list in UniConnection, and select the created DSN.