Web Scraper and Web Macros FAQs

  • 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 [TheColumnHeaderYouChose] FROM [SHEET1$]

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

Good Luck!
Create a Page | Administration | File Management | Login/Logout | Language Selection | Your Profile |Create Account