cancel
Showing results for 
Search instead for 
Did you mean: 

How to connect to local excel file from Universe designer?

Former Member
0 Kudos

Anybody know how to connect to a local excel file from Universe designer? Please provide steps one by one. Thanks.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

1) On BO Server create an ODBC connection to your Excel file. (You should see the Excel driver in the list of options when you choose Add)

2) In Universe chooses Tools -> Connections

3) Select Generic ODBC connection and click okay. Follow wizard steps and select the ODBC connection

Regards

Alan