Cannot add an Excel sheet into an Universe

[Rajua99]

Hello,

I was able to create a connection for my excel sheet by keeping the array size to 1 and it is responding also. when i am parsing the objects i am getting this error message for all the objects that exists in my excel sheet. I got only 2 colums in my excel sheet and both of them are number only.

Parse failed: [Microsoft][ODBC excel driver] syntax error in From clause.

Thanks
Alluri[/b]

[Rajua99]

I was succesfull in creating the Unvierse using excel sheet using the pdf provided by Robert Metzker in his website how to create Universe from excel file

Here is the Link to this website.

http://homepage.mac.com/rmetzk/Busobj_Tutorials.html

Thanks,
Alluri

[bodevXI]

Hi,

We have a requirement to create universe with Excel as data source.
We are getting the error " Optional Feature Not Implemented"


As mentioned while creating we took care that the Array Fetch Size is set to 1.
What is the purpose behind selecting the ODBC3 connection?
Is this the reason for getting the above mentioned error?

Please respond .......
This is an urgent requirement.

[cart3r]

Hi,

I'm having trouble creating a working universe based off my excel sheet. The ODBC connection is valid and the connection test works in Designer.

I'm able to create objects based off the data in Excel.

However, when I go to the SQL viewer inside each object, it says the server is not responding (QP0016).

I also get the Parse failed: Drive not capable : Transactional Mode error when I try to parse the objects.

I used the Microsoft Excel Driver to create the ODBC link and tried both the Generic ODBC and Generic ODBC3 connectors in Designer.

Any ideas?

thanks

[cart3r]

problem resolved. for my particular case, i changed the

<Parameter Name="Transactional Available">NO</Parameter>

to

<Parameter Name="Transactional Available">Yes</Parameter>

in the odbc.sbo file.