Skip to Content

Excel workbook cannot see worksheet

Hi everyone,

When setting up a new Excel Workbook file format we are not getting the option of selecting which worksheet to use. We have selected the file directory, selected the file, but when we select the worksheet radio button no worksheet names present in the drop down. We tried puttint the worksheet name manually, then selecting import metadata, but then we got the "OLE or COM processing error. Please make sure Microsoft Access Database Engine is properly installed: <Unspecified error>. (BODI-1112338)" .

We re-installed Microsoft Access Driver for both 2007 and 2010 thinking that would help but no luck. We are using DS_40_32Bit Designer on Windows XP machine.

Has anyone seen this error before and what can we do to fix this?

TIA

Lynne

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2012 at 11:16 PM

    Hi Lynne,

    It looks like you did everything correctly, but could you just confirm my reading the Windows Installation manual:

    http://service.sap.com/~form/sapnet?_SHORTKEY=01200252310000089713&_SCENARIO=01100035870000000202&_OBJECT=011000358700001323832010E

    and confirm your configuration is supported (no 64 bit OS, no Excel version conflict..). You could add your configuration in the next post if it does not work.

    Just open the manual and search for Excel.

    Regards

    Norbert

    P.S: Does this only happen on this machine or do you have other clients this works on?(your Server?)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2012 at 04:04 AM

    Hello

    You have to select the File name and directory once again, if that is selected in a proper way you can see the work sheet name in work sheet drop down. Normally it is the problem with file name. Try to drop down> select file and select the document once again.

    By manually entering the work sheet name it will not work and that's the reason it is showing the error message I guess. If you do not have version problems, try to load that excel sheet in two three attempts, as it will load at last.

    Regards

    Niveditha.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 25, 2012 at 08:56 AM

    Hi Lynne,

    What is the full version of Data Services (eg: 14.X.X.X)? If you are on a base version it worth to upgrade to SP3.

    Thank you,

    Viacheslav.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.