• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 429
  • Last Modified:

Importing Brio table from Access Database


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.

1 Solution
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.

What do you prefer, linking or importing ?

Is there an ODBC driver for this DB? if so u can create this and then use DoCmd.TransferDatabase to make your import

I found this
from the link http://www.asu.edu/data_admin/data_warehouse-FAQ.html#access

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now