Connect Access to Business Objects.

Darren Bartrup

Well-known Member
Joined
Mar 13, 2006
Messages
1,297
Office Version
  1. 365
Platform
  1. Windows
I haven't posted this in the Access forum as I think it's more of a Business Objects question.

I have an Access database containing a list of customer reference numbers.
What I'd llike to do is make this list available to Business Objects so I can look these numbers up against an Oracle database (we already have universes set up for the Oracle database).

Does anyone know how to do this please?
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Thanks for the reply Giacomo.

I did find some code which imported the last ten emails from Outlook into Business Objects, but for some reason it vanished from the Macro list after you'd run it once (even though the code was still there).
I tried to alter this so it would work with my database, but no luck so far.

I might stick with my workaround - export the required field data to a csv or xls file (making sure not to break the 1000 record limit) and run a BO report connected to this, export the result as another csv file and import this back into Access.

Long winded if done by hand, but brings gasps of approval when done using code (it's so easy to impress the un-enlightened) :lol:
 
Upvote 0

Forum statistics

Threads
1,225,229
Messages
6,183,728
Members
453,185
Latest member
radiantclassy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top