Last post Jan 14, 2011 08:35 AM by mehta.rahulit
Jan 14, 2011 07:45 AM|kamenv3|LINK
I am trying to write a page to read the Excel file provided by the user. I know I can't use the FileUpload to get the full path of the file from the client PC. This give me the problem when I write the connection string for the Excel file:
Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\Doc\Book1.xls;" & "Extended Properties=""Excel 8.0;"""
Without the full path, I can't replace the Data Source by a variable and I definitely can't assume all users will have their Excel files named Book1.xls located in C:\Doc\ all the time.
What I can do?
Jan 14, 2011 08:35 AM|mehta.rahulit|LINK
copy the excel to sever from client machine
then give server path