Page History: Using Excel as input to a package.
Compare Page Revisions
Page Revision: 2009/01/02 18:28
- Make sure to add a column header to the Excel file and that the sheet's name is SHEET1.
- In your package properties -> Steps tab, click the New... button to create a new task.
- Click through to the Build a List of Urls step and select the Excel Spreadsheet option.
- Choose the bottom radio button to connect to an existing spreadsheet.
- Check the box "The existing file's first row is column headers."
- Complete the wizard and open up the new task's properties.
- Go to the File List or Form List tab and change the query:
SELECT F1 FROM SHEET1$
to
SELECT TheColumnHeaderYouChose FROM SHEET1$