Using Excel as input to a package.

* Make sure to add a column header to the Excel file with your input data and check that the sheet's name is SHEET1 in the bottom left.
* 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 &#0091;F1&#0093; FROM &#0091;SHEET1$&#0093;}}}}
to
{{{{SELECT &#0091;TheColumnHeaderYouChose&#0093; FROM &#0091;SHEET1$&#0093;}}}}

* Now hit the test link on the bottom right to test your query.

Good Luck!

Web Scraper and Web Macros FAQs

Navigation

Using Excel as input to a package.