Skip to Content
0

Excel sheet not recognised in Data Services Designer

Feb 22, 2017 at 06:57 AM

200

avatar image

Here When i want to load an Excel file in Data Service Designer.But When I click on Worksheet there are no work sheets displayed in Drop down menu .I am using Microsoft 2010 32 bit version..Any inputs welcomed

TIA

ds1.jpg (49.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Arun Sasi Feb 23, 2017 at 08:17 AM
0

Have you placed the excel file on the Job Server?

Whats your Data Services version?

Regards

Arun Sasi

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Arun,

I placed my excel file on job server.Currently we are using Data Services 4.2 Sp4

0

Try installing 64 bit version of MS Excel Application

Regards

Arun Sasi

0
Matthew Ong Apr 10, 2017 at 08:20 PM
0

Does your local PC client that is running the BODS Designer have Microsoft Office installed on it?

Best Regards,

Matthew Ong

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Yes MS office 2010 in installed

0