Solved

Importing Brio table from Access Database

Posted on 2006-11-13
2
368 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 500 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

861 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

Need Help in Real-Time?

Connect with top rated Experts

29 Experts available now in Live!

Get 1:1 Help Now