microsoft ace oledb 12 0 connection string

/// /// Obtain Excel Data to dataset Jia Shiyi/// /// /// /// Public static dataset getdatafromexcel (string filename, bool isfirsttitle){Dataset DS = NULL;String strconn = "provider = Microsoft. Ace. oledb.12.0; Data Source =" + filename + "; extended properties = 'excel"+

When accessing the Excel data source, Microsoft. Ace. oledb.12.0 is not registered on the local computer.Program1. Make sure that the Microsoft. Ace. oledb.12.0 driver is installed. Http://download.microsoft.com/download/7/

information about how to use the driver, see the application documentation.2. If you are an application developer using oledb, set the provider parameter of the connectionstring attribute to "Microsoft. Ace. oledb.12.0"To connect to Microsoft Office Excel Data, add "Excel 1

Microsoft softoffice2013 is installed in windows. When importing an Excel file from SQLServer2008, the following message is displayed: Microsoft. ACE. OLEDB.12.0 provider is not registered on the local computer. (System. Data) solution: download and install the 2007Officesystem DRIVER: Data

Note: An error occurred while executing the current Web request. Check the stack trace information to learn about this error andCodeDetailed information about the cause of the error. Exception details:System. invalidoperationexception: Microsoft. Ace. oledb.12.0 is not registered on the local computer.Program. Baidu has not found a solution for a long time.

Database connection string-Microsoft Access ODBC DSN // ODBC DSN Using system. Data. ODBC; Odbcconnection conn = new odbcconnection ();Conn. connectionstring = "DSN = dsnname ";Conn. open (); ODBC -- standard security // ODBC -- standard security Using system. Data. ODBC; Odbcconnection