?
Solved

Importing Brio table from Access Database

Posted on 2006-11-13
2
Medium Priority
?
422 Views
Last Modified: 2008-01-16
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.



0
Comment
Question by:chtullu135
2 Comments
 
LVL 54

Expert Comment

by:nico5038
ID: 17931994
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 ?

Nic;o)
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 2000 total points
ID: 17932009
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
http://www.asu.edu/data_admin/WUG/Setting%20Up%20Access%202000%20Updated.pdf
from the link http://www.asu.edu/data_admin/data_warehouse-FAQ.html#access

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question