Skip to Content

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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply