Importing Brio table from Access Database

Hello,

I have a client, using Hyperion Intelligent Client, who wants to import a brio table into an access database. I'm thinking that it may be easier to export the bio table via a OCE connection to the Access database. I'm not sure how to go about importing a Brio table into access via VBA code. I would appreciate any help.

When you can export the Brio table into a .csv format, it will be easy to import using the standard import function of Access you get as option when creating a new table.
When you have ODBC you can also use the linked table option and a table make query to move the data.