October 18, 2017 at 3:27 am
Dear All,
I have an excel file that has header information which is not relevant for me . Column names start on row 11 and data continue from there.
How can I say in my connection manager or excel data source that this file should only start to be read from column 11?
Thank you
October 18, 2017 at 3:53 am
You can use a SQL statement instead to tell ACE where you want to get the data from. So, assuming that you column headings are on row 11 and your data in rows A-Q and your worksheet is called "Sheet1", you would enter the following for your SQL statement in your Excel source:SELECT *
FROM [Sheet1$A11:Q]
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 18, 2017 at 5:36 am
Hello,
Thank you very much for your reply. Yes. My column names are in 11 and worksheet name also ok.
There is only one thing. Colum names start on position A11 and finish on position L11
But the rows that I want to read (below the columns) are many. In one file can be 100 and on the other 1000
So, asside the fact that I can say what are my column start, how can I say to SSIs to read the file till the end?
October 18, 2017 at 5:43 am
river1 - Wednesday, October 18, 2017 5:36 AMHello,Thank you very much for your reply. Yes. My column names are in 11 and worksheet name also ok.
There is only one thing. Colum names start on position A11 and finish on position L11
But the rows that I want to read (below the columns) are many. In one file can be 100 and on the other 1000
So, asside the fact that I can say what are my column start, how can I say to SSIs to read the file till the end?
The source will stop when it gets to the EoF. That could be row 100, row 1,000 or row 1,000,000.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply