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

/wp-content/uploads/2012/12/1new_169402.png

/wp-content/uploads/2012/12/2import_169406.png

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

Select Import Schema

/wp-content/uploads/2012/12/3adjust_169407.png

Adjust the field types and links as necessary and click OK

/wp-content/uploads/2012/12/4viewdata_169408.png

Right click and View Data

/wp-content/uploads/2012/12/5viewdata_169409.png

Assigned Tags

      2 Comments
      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