Knowledge Sharing of My Experience

Server Support - IIS 7.5 - ASP.NET Framework 4.0 (Chart) - ASP.NET Crystal Report - ASP.NET Connect Office Files. - ASP.NET AJAX Instruction 1. Install Operating Systems Windows Server 2008 R2 64-bits 2. Go to Server Manager > Roles > Add Roles > Check box Web Server (IIS) 3. Go to Server Manager > Roles > Add Roles Services > Check box     - Application Development (ASP.NET, .Net Extensibility, ASP, ISAPI Extensions, ISAPI Filters)     - Security (Basic Authentication, Windows Authentication, Digest Authentication)     - FTP Publishing Service 4. Go to Server Manager > Feathers > Add Feathers > .Net Framework 3.5 Feature 5. Install dotNetFx40_Full_setup.exe 6. Install CRRuntime_64bit_13_0_1.msi 7. Install ASPAJAXExtSetup.msi 8. Install AccessDatabaseEngine_x64.exe

1. Install Package Microsoft Access Database Engine 2010 Redistributable 2. Import NameSpace Imports System.Data Imports System.Data.Oledb 3. Development Dim myDataset As New DataSet() ''You can also use the Excel ODBC driver I believe - didn''t try though Dim strConn As String = " Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Excel.xlsx;Extended Properties=""Excel 12.0 Xml;HDR=YES""; " ''You must use the $ after the object you reference in the spreadsheet (## Table Name is ExcelTest ##) Dim myData As New OledbDataAdapter("SELECT * FROM [Sheet1$]", strConn) myData.TableMappings.Add("Table", "ExcelTest") myData.Fill(myDataset) DataGrid1.DataSource = myDataset.Tables(0).DefaultView DataGrid1.DataBind() Refer :: Connection String