WS 2008 R2 64bits
Install the package AccessDB
AccessDatabaseEngine_x64.exe
Click on datasource ODBC (Open Database Connectivity) on the NBI server
Go to system DSN (Data source name) tab
Set up the DSN and the excel file
Connect to the NBI and go to Admin/Connections
Create a new connection as following:
| File | Size | Date | Attached by | |||
|---|---|---|---|---|---|---|
| 725px-Connection_string_NBI.jpg No description | 76.07 kB | 10:17, 18 Oct 2013 | Admin | Actions | |
| AccessDatabaseEngine64.jpg No description | 15.22 kB | 10:19, 18 Oct 2013 | Admin | Actions | |
| Data_sources_ODBC.jpg No description | 49.65 kB | 10:17, 18 Oct 2013 | Admin | Actions | |
| Installation_ODBC_pour_microsoft_excel.jpg No description | 34.07 kB | 10:17, 18 Oct 2013 | Admin | Actions | |
| NBI_connections.jpg No description | 20.1 kB | 10:17, 18 Oct 2013 | Admin | Actions | |
| ODBC_data_source_administrator.jpg No description | 44.41 kB | 10:17, 18 Oct 2013 | Admin | Actions | |
Comments