Skip to Content
Author's profile photo Tammy Powlas

How to Import an Excel File in Data Services

How to use an Excel file as a source object in Data Services 4.0 SP1

In the Local Object Library right click on Excel and select New



Select Excel sheet, and select range and settings as shown above

Select Import Schema


Adjust the field types and links as necessary and click OK


Right click and View Data


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Warren Rocchi
      Warren Rocchi

      I am getting an error: "Cannot open file <C:>. Please check the files path and permissions"

      could you please assist?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi - it sounds like you have an operating system authorization issue; please contact your network administrator