Is there a way import a complex Excel spreadsheet in RS and use that to generate new spreadsheets with having Excel installed? TIA!
David L. Crooks
If you wanting to use a SSRS model to report from the Report Builder you can create a view that looks at the EXCEL sheet as a "linked server".
Once the view is created you can create a dsv with SSRS and then you will be able to report off that model.
Then, using the export function or subscription you can generate xls/csv files.
No one has followed this question yet.