April 14, 2009 at 8:09 am
Hello
I'm trying to query a multiple tabbed excel spreadsheet. happy days 🙁
However I need to map a date from on sheet which is on the 117th row of column F2.
I dont need anything else from that sheet.
Is is possible to query the excel source and filter the rows?
i.e select F2 from [sheet1$]
where ~row~ = 117
Its easy to filter by column... but what about row? Surely there must be away
April 14, 2009 at 8:24 am
This is a very bad rookie solution that i am recommending but, if u dont want to waste anymore time - just dump everything into a Temp table with an identity, then select from the table your 117 row
🙂
sorry for the rookie solution, but dont know the exact answer. I tried to filter but SSIS wouldnt write a query against it. Maybe i am using a wrong provider, maybe if i changed the provider, or used OPENQUERY ... again, all of these are a maybe.
I too want to know if u could do that on an excel file.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply