No announcements
Found 2182851 threads
-
0 VotesLoop through excel file sheets in ssis
Answered | 15 Replies | 9573 Views | Created by Naveen Mbv - Thursday, February 12, 2015 10:22 AM | Last reply by Naveen Mbv - Monday, February 16, 2015 7:13 PM
-
1 Votes
Loop through array of Excel sheets
Sub Test() Sheets.Select With Sheets(1) .Range("A1") = "Nr" .Range("A2") = 9 ...Answered | 2 Replies | 528 Views | Created by ryguy72 - Sunday, July 31, 2016 3:03 AM | Last reply by ryguy72 - Tuesday, August 2, 2016 3:03 PM -
0 Votes
How Excel Sheet and named ranges display in SSIS
http://beyondrelational.com/modules/24/syndicated/398/Posts/18163/ssis-how-to-loop-through-multiple-excel-sheets-and-load-them-into-a-sql-table.aspx ...Answered | 4 Replies | 2434 Views | Created by Naveen Mbv - Wednesday, April 1, 2015 7:50 AM | Last reply by Naveen Mbv - Thursday, April 9, 2015 7:35 AM -
0 Votes
Loop through Excel workbooks and sheets.
Hi aivoryuk, In this case, if setting the “FirstRowHasClolumnName” as true in Excel connection, when loading the records from sixth row, the ...Answered | 8 Replies | 1136 Views | Created by aivoryuk - Friday, May 27, 2016 10:25 AM | Last reply by aivoryuk - Friday, June 3, 2016 1:42 PM -
0 Votes
Loop Query Through Date Range
Here are my two Cents, please see this link: How to import data from Excel to SQL Server and Exporting SQL Server Data to ...Answered | 2 Replies | 1906 Views | Created by Dan86 - Thursday, August 29, 2013 5:30 PM | Last reply by Saeid Hasani - Thursday, August 29, 2013 7:15 PM -
0 Votes
Loop through Excel files in SSIS
Retrieve file name: fully qualified.Answered | 8 Replies | 6536 Views | Created by Milli_22 - Tuesday, November 3, 2009 2:43 PM | Last reply by Sudeep Raj - Tuesday, November 3, 2009 5:01 PM -
3 Votes
Finding if a range name exist in workbook (Excel 2003) with C++?
Ahh my mistake I forgot it concatinates the sheet name into the name of the "name".Answered | 8 Replies | 4169 Views | Created by ldhartzman - Thursday, August 11, 2011 9:25 PM | Last reply by Scott Gall - Tuesday, August 16, 2011 7:10 PM -
0 Votes
Loop through Excel File with multiple worksheets
Have a For Each loop with file Enumerator to loop through files 2.Answered | 3 Replies | 2434 Views | Created by Vikash Karra - Thursday, June 29, 2017 6:28 PM | Last reply by Visakh16 - Friday, June 30, 2017 5:07 PM -
0 Votes
Visio Viewer and excel named ranges
I link shape to range of Excel and then open it in IE and Visio program.Answered | 2 Replies | 1119 Views | Created by Stevemorin - Monday, August 22, 2016 7:54 PM | Last reply by Al Edlund - Tuesday, August 23, 2016 11:56 AM -
1 Votes
Looping through two unions of non-contiguous ranges
Each separate range of the Union is an Area and you work in the Areas of the Unions.Answered | 2 Replies | 3353 Views | Created by NiklasKokeritz - Thursday, February 16, 2012 2:38 PM | Last reply by OssieMac - Thursday, February 16, 2012 8:08 PM -
0 Votes
Problem with variable (Excel tab name) in a Foreach Loop
The solution you're using also returns "named ranges".Answered | 5 Replies | 5215 Views | Created by LRHumberto - Thursday, October 3, 2013 10:05 PM | Last reply by Ghneim - Thursday, November 3, 2016 2:04 AM -
0 Votes
How to select a range in Excel 2007 and name this range?
Sub Macro8() Dim range1 As Range Set range1 = Range(ActiveCell, ...Answered | 4 Replies | 467 Views | Created by Leon Lai - Thursday, January 14, 2016 2:36 PM | Last reply by Leon Lai - Friday, January 15, 2016 7:24 AM -
0 Votes
How to loop through Excel files in SSIS
can you provide me some link by which i can perform this task first i want to know about how can we add data of five different file having same column ...Answered | 10 Replies | 8006 Views | Created by Ajay Singh Rawat - Tuesday, April 17, 2012 10:57 AM | Last reply by Christa Kurschat - Tuesday, April 17, 2012 12:20 PM -
0 Votes
How to loop through records in a query and write to Excel?
Among your other problems, your code defines and sets two different Recordset objects, one named "MyRecordset" and one named "rs".Answered | 6 Replies | 1056 Views | Created by ryguy72 - Wednesday, May 11, 2016 3:45 PM | Last reply by ryguy72 - Wednesday, May 11, 2016 6:21 PM -
0 Votes
Import Data via SSIS, from an excel named range to master excel named range
Set Data Access mode to "Table or view" Select a specific sheet under "Name of the excel sheet" On the ...Answered | 4 Replies | 8096 Views | Created by srituraj - Monday, May 7, 2012 3:38 AM | Last reply by RyanAB - Wednesday, November 12, 2014 2:59 AM -
2 Votes
Looping through month in a range of dates?
SELECT DATEDIFF(MONTH,'19000101','20090101') For more information, I would suggest you have a look at the link ...Answered | 3 Replies | 50511 Views | Created by rbhatup - Friday, November 25, 2011 3:01 PM | Last reply by KJian_ - Monday, November 28, 2011 7:49 AM -
0 Votes
loop in a loop with excel
Hi Abdus, For this requirement, you could loop cells and using Range.Find method to find the corresponding value in specify range.Answered | 3 Replies | 493 Views | Created by Abdus Sattar - Tuesday, January 5, 2016 2:18 PM | Last reply by Starian chen - Thursday, January 7, 2016 2:27 AM -
0 Votes
SQL Syntax To Import A Named Range From Excel
You can use this as mentioned above....What i would do is INSERT INTO New_Table SELECT ...Answered | 2 Replies | 2301 Views | Created by FARAZ A QURESHI - Sunday, July 13, 2014 9:14 PM | Last reply by Abubeker Refaw - Sunday, July 13, 2014 11:52 PM -
0 Votes
loop through the excel files in folder and sub folder
Take a look at the Foreach Loop.Answered | 1 Replies | 996 Views | Created by Alpula Srinivas - Wednesday, January 28, 2015 1:23 PM | Last reply by Andy Tauber - Wednesday, January 28, 2015 4:43 PM -
0 Votes
How to write a for-loop to search a range?
I'm new to programming actions in Excel so please forgive me if my question sounds simple or stupid.Answered | 2 Replies | 3315 Views | Created by 2Chucky - Thursday, February 26, 2009 7:12 PM | Last reply by 2Chucky - Friday, March 6, 2009 6:58 PM - Items 1 to 20 of 2182851 Next ›
No announcements
