programmer2programmer :: Microsoft MS Excel Connection Strings for OLEDB and ODBC. Connect Excel Sheet to your application

Welcome to www.programmer2programmer.net for the MS Excel 97, 2000, XP, 2003 Connection Strings

	100% Tested Ready Academic IT Projects
BE, ME, BTech, BCA, MCA, MBA, Bsc-IT, MS, BIT, ADIT, DOEACC, IGNOU, SMU
readymadeproject.com

Microsoft MS Excel Connection Strings for OLEDB and ODBC. Connect Excel Sheet to your application

Home

Personal

Member

Forum

Source

Project

Tips

Contact

Largest collection of Connection Strings on Internet for -

	MS Excel Connection Strings	1. SQL Server 2000 Connection Strings
		2. SQL Server 2005 Connection Strings
		3. SQL Server 2005 CE Connection Strings
MS Excel 97, 2000, XP, 2003 Connection Strings including ODBC, OLE DB Connection Strings which can be used to connect MS Excel sheet to your frontend application.		4. Oracle Connection Strings
		5. MySQL Connection Strings
This is the complied and tested collection of Microsoft Excel including MS Excel 97 -2003 ODBC and OLE DB Connection String.		6. Postgree SQL Connection Strings
		7. MS Excel Connection Strings
		8. MS Excel 2007 Connection Strings
		9. Text/CSV File Connection Strings
		10.MS Access Connection Strings
		11.MS Access 2007 Connection Strings
		12.VisualFoxPro/FoxPro 2.6 CS
		13.DBF Connection Strings


ODBC Connection String for MS Excel
	Standard Security
		Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;


OLE DB Connection String for MS Excel
	Standard Security
		Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
		Dim QueryExcel As String Dim CommExcel As OleDb.OleDbCommand Dim DaExcel As New OleDb.OleDbDataAdapter Dim TableExcel As New DataTable Dim CnExcel As New OleDb.OleDbConnection CnExcel.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & TxtExcelPath.Text & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""" If CnExcel.State = ConnectionState.Closed Then CnExcel.Open() QueryExcel = "Select * from [" & SName & "$]" CommExcel = New OleDb.OleDbCommand(QueryExcel, CnExcel) DaExcel.SelectCommand = CommExcel DaExcel.Fill(TableExcel) CnExcel.Close()

Connection Strings Main