Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranganathanmca
Starting Member
15 Posts |
 Posted - 2011-03-02 : 00:45:43
|
Hi guys.,I am facing some problem from Excel source file reading because i need to read sheet1$ from column B16 to column R16 data with end of excel document using below queryQuery : SELECT * FROM [sheet1$b16:R16]but it's displaying only one row please give me some suggestion.,one more suggestion also : i don't wanted to upload Last 3 row record of the excel document please suggest me to avoid those row query thanks for u r great help  ranganathan palanisamy |
|
|
latch
Yak Posting Veteran
62 Posts |
Posted - 2011-03-04 : 12:27:21
|
| Hi,i got the same problem today with my excel file, how i resolved is :after it showing the columns as one column go to the advanced editor of the source transformation and add new column by specifying the column delimiter and row delimiter make sure both should not be same add as many as needed.To avoid the end rows in the excel file take conditional split transformation and use a expression to avoid the unwanted rows if you can provide the sample i can give you the expression.hope it helps.Thanks,latch |
 |
|
|
|
|
|
Excel file Reading