I am creating a web application that imports excel files into a database. What occurs is that i have several excel files that I need to import from excel into a database. These files could be excel 97-2003 or excel 2007/2010. I have it determine which filetype it is and use the particular connection. This is how my code looks.\n[CODE]\nDim strconn As String\n If fileextesnison = ".xlsx" Then\n strconn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + \n ";Extended Properties=""Excel 12.0 Xml;"";"\n ELSE\n strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath+ \n";Extended Properties=""Excel 8.0;"";"\n End if\nDim strSQL as string = "SELECT * FROM RangeName"\nDim olConn As New OleDbConnection(strconn)\nDim oadapter As OleDbDataAdapter\n olConn.Open()\nDim od As New OleDbCommand(strSQL, olConn)\n oadapter.selectcommand = od\nDim oData as dataset \n oadapter.fill(odata, "Data")\n olConn.Close()\n[/CODE]\n\nBefore the above process happens I am using softartisan excel writer to add a range name cause I am using the range name to select the data and adding [ and ] in the column names in case the column names are not valid database column name format. The issue is that when I try to import the file that is excel 97-2003 it gives me the microsoft jet database engine could not find 'RangeName' and please make sure that the path and filename is correct. When I try this with excel 2007/2010 it imports the file and have no issues. I have checked the filepath and it is directing to the proper file. What could be the issue that is occurring here?