Skip to Content
0

DSN to an Excel file on AIX server

Jan 06, 2017 at 11:00 AM

74

avatar image

Hi,

We are on BO 4.1 sp6, and the BO server is installed on AIX. I have to create a Universe from Excel file.

How do I check the driver manager on AIX, for creating a DSN to Excel file.

What should be the parameters to be put on odbc.ini file for the dsn, and is there any specific location to put the Excel file?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Stéphane DUPONT Jan 06, 2017 at 11:05 AM
0

Hi

It's Unix, not Windows, you can't connect to Excel.

See http://scn.sap.com/docs/DOC-67214 for other features unsupported

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

Thank you Stephane.

The link is really helpful.

Is there any other way to create Universe from excel in my case? Can I load data in a table and transport to some database to use?

0