Importing Brio data

[KMaples]

I've searched the forum, but can't find anything on Brio. My problem is that I have to use Brio to query our Data Warehouse, but cannot import the results into Access. Does anyone have experience with Brio? Thanks

 

[Robert88]

Hi KMaples,

Do not know anything about Brio but I am assuming you could look to export to a txt or CSV files form Brio? If this is the case Acess can read these types of files.

Hope it helps.

Robert88

 

[KMaples]

Importing Brio Data

Thank you for the response; I will look at doing just that.

 

[systematic]

I am indeed using a combination of Access and Brio (actually Hyperion - which I believe is the latest version).

I have not been able to find a way to get my data to Access directly, but am using the following process that may or may not help you -

1. BRIO emails a daily report automatically (excel)
2. I save the file to a specified location (replace the same file each day)
3. I have a function attached to a command button that -

- Imports the spreadsheet to tblTEMP
- Tidies up the data (runs a query)
- Appends tidied data to tblDATA
- Deletes tblTEMP
- Deletes tables with import errors (if there are any)

I find this process easy - takes about 30 seconds all in all.

Hope this helps

Regards

Robert