Excel Connection Strings
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Orginal.xls;Extended Properties=Excel 8.0;Persist Security Info=False"
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Now () Function in SQL Server 2005 Logs, Status Reports and et al., Now() function is common. Here is the way to accomplish the same in SQL ...
-
Get the HOST NAME / COMPUTER NAME Get the Computer Name using SQL Query Select Host_Name() as Computer_Name Get Computer Name, Get HOst Name...
-
How to Create Primary Key in SQL Server Management Studio In Table Designer, click the row selector for the database column you want to defi... -
While loop in T-SQL Here is a simple example of While loop Declare @temp tinyint = 1 while ( @temp 11 ) begin print cast ( @temp...
-
How to check if a text exists within another in SQL Server 2008 / How to split SQL Column based on Comma You can use the combination of Ch...
-
All About Connections @@MAX_Connections Returns the maximum number of simultaneous user connections allowed on an instance of SQL Server. Th...
-
TimeStamp Column in SQL Server TimeStamp is used to store unique binary numbers within a database. This column is autogenerated with a sto... -
This error occurs when a variable name is preceded by # instead of @. # is used to declare temporary table declare #myi int Should be repl...
-
********************Youngest & Oldest Employee******************** To get the youngest / olderst employee, two different methods are sho...
-
ADO Connection String for Access 2007 Database Here is the ADO connection string example for Access 2007 database. Set Cn = New ADODB.Co...
2 comments:
Alternative Sample :
With or without column header ...
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\MyExcelFile.xls;Extended Properties=""Excel 8.0;iif(hdr,yes,no)"""
Alternative Sample :
With or without column header ...
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Orginal.xls;Extended Properties=""Excel 8.0;iif(hdr,yes,no)"""
Post a Comment