Hi,
I frequently create Excel spreadsheets that use MS Query to retrieve data from Access .mdb files using an ODBC connection. Is it possible to do the same thing pointing to a .bqy file? I have already processed the queries in the .bqy, so it contains the data I need, this should just be a case of creating the ODBC connection. But I can't find a Brio or Hyperion driver that lets me create an ODBC connection direct to a .bqy file. Is this possible?
Thanks,
Johnny Geo
I frequently create Excel spreadsheets that use MS Query to retrieve data from Access .mdb files using an ODBC connection. Is it possible to do the same thing pointing to a .bqy file? I have already processed the queries in the .bqy, so it contains the data I need, this should just be a case of creating the ODBC connection. But I can't find a Brio or Hyperion driver that lets me create an ODBC connection direct to a .bqy file. Is this possible?
Thanks,
Johnny Geo