To import Excel into a database table:

1. Upload the Excel document to the server;

2. Read the data in Excel on the server into the database.

Experience:
NPOI.dll component, need to know the full path of the imported Excel file, so I tried to <input type= "file" > control on the server side to get the full path of Excel file on the client, will it be established?
After trying to know: can not get the full path!!
Cause: Browsers have been unable to get to the real path on this machine for security reasons, the server side is not able to access the client's files

To import Excel into a database table: