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 |
|
sammyboy
Starting Member
1 Post |
 Posted - 2007-05-01 : 21:28:20
|
| Hi,I have an Excel 2007 file which contains values in specific cells like A23, D30 etc.I want to populate the values in these cells using SSIS packages into individual rows of an SQL table.How can this be achieved ?CheersSam |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-05-02 : 12:23:23
|
| Thank you Sam for asking this, I will follow this thread.I actually have a similar question, not sure if I need to start another thread?What I want to do is to Select * from database1 where (column1 = Spreadsheet1.column1.cell1 and so on)If people feel, I am hijacking your thread, I can start a new one.RegardsParesh MotiwalaBoston, USA |
 |
|
|
|
|
|
Excel 2007 cell data query