Web Scraper and Web Macros FAQs

Page History: Using Excel as input to a package.


Compare Page Revisions



« Older Revision - Back to Page History - Current Revision


Page Revision: 2009/01/02 18:31


  • 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 [F1[ FROM [SHEET1$[
to
SELECT [TheColumnHeaderYouChose[ FROM [SHEET1$[

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

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