1) Create a sample Excel file - only few records
2) Created a System ODBC connection pointing this excel file say "TEST1"
3) Opened A Blank Crystal Report
4) Create a New connection
5) Select ODBC RDO
6) Create new connection and selected the newly created SYSTEM DSN "TEST1"
7) Right Click on the connection (created)
8) Select "options" in window
9) it will show multiple check boxes for different options.
10) Select the checkbox for System Tables under Data Explorer.
11) click Ok & Exit
12) Refresh the ODBC connection by right clicking it.
13) you should be able to see the selected excel sheets in the ODBC connection.
2) Created a System ODBC connection pointing this excel file say "TEST1"
3) Opened A Blank Crystal Report
4) Create a New connection
5) Select ODBC RDO
6) Create new connection and selected the newly created SYSTEM DSN "TEST1"
7) Right Click on the connection (created)
8) Select "options" in window
9) it will show multiple check boxes for different options.
10) Select the checkbox for System Tables under Data Explorer.
11) click Ok & Exit
12) Refresh the ODBC connection by right clicking it.
13) you should be able to see the selected excel sheets in the ODBC connection.
கருத்துகள் இல்லை:
கருத்துரையிடுக