SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag Excel Rss

Search for any content tagged excel

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 3 of 3   

Convert int to Excel column name

This script converts a numeric column index to an Excel column name (ex: AC)  Read more...
By Peter Diplaros 2013/11/07 | Source: SQLServerCentral.com | Category: excel
Rating: (not yet rated) |  Discuss |   Briefcase | 1,348 reads

Create INSERT statements from Excel

Excel files includes a very good functionality called Macro execution. And here we can use this functionality to write one macro that will generate INSERT statements.  Read more...
By Arun Mallick 2011/05/02 | Source: SQLServerCentral.com | Category: insert
Rating: |  Discuss |   Briefcase | 5,323 reads

My favorite way to access Excel files

Using opendatasource to retrieve data from Excel files as if querying a table.  Read more...
By Gaby Abed 2011/03/22 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 11,523 reads
   Items 1 to 3 of 3