Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 importing data via SSIS
I have an excel spreadsheet which runs from columns A - X. Column. There are
formulas and data validation rules in columns T - X, and data is being imported via SSIS into columns A - S which are completely empty The problem is, when the data is being written to the xls, it actually jumps to the end of the rows containing formulas before writing. So, if I had copied my formulas/validations down to row 100, the data from SSIS starts at row 101, despite the fact that the columns it is writing into are blank. Would appreciate any help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data in excel 2003 | Excel Discussion (Misc queries) | |||
SSIS package converting int's to text in Excel | Excel Discussion (Misc queries) | |||
Locking column widths & importing data in Excel 2003 | Excel Discussion (Misc queries) | |||
Importing data into Excel 2003 from a Web site | New Users to Excel | |||
Importing data into Excel 2003 from a Web site | Excel Discussion (Misc queries) |