- Connecting to Microsoft Access and Excel

Connecting to Microsoft Access and Excel

Web Object Wizard supports Microsoft Access and Excel 2000 or above, which is supported by the latest JDBC-ODBC driver. You may have connection problems if trying to connect to a version under Microsoft Access/Excel 2000. To connect to Access or Excel, you must create an ODBC System Data Source on the same system that you have your application server installed. The DSN must bepointed to your desired Access database or Excel worksheet.

URL - jdbc:odbc:data_source_name

Example: jdbc:odbc:Northwind (connecting to a MS Access database Northwind)

WOW must be able to resolve the data source name.

See Interfacing WOW with Excel for more details.