I am trying create a method, which can insert data into database using excel file, as input. when I upload, xls file on the client-side and click upload button, the application throws back error message:
The Microsoft Access database engine could not find the object 'product'. Make sure the object exists and that you spell its name and the path name correctly. If 'product' is not a local object, check your
network connection or contact the server administrator.
here is the code, I am currently using:
protected void btnImport_Click(object sender, EventArgs e)
{
if (FileUpload1.PostedFile.ContentType == "application/vnd.ms-excel" ||
FileUpload1.PostedFile.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
try
{
string excelPath = Ser ...
Go to the complete details ...