Using Oracle XE as a Data Source

B

buclao

New Member
Joined
Oct 1, 2011
Messages
21
I will be migrating my database from MS Access 2007 (*.accdb) to an Oracle XE. Any good links or papers on this or possibly any past experience with this ?
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Sort by date Sort by votes
Sorry, I don't know much about Oracle. Best bet is to see if there is an ODBC driver for Oracle XE, try installing that on your desktop, then trying to connect to that driver from PowerPivot.
 
Upvote 0
In case anyone reads this, I was able to connect using Oracle Instant Client (Basic + SQLPLus) without even the need to creat a TNS connection string.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question Question
How to add a custom column that identifies the page number data was extracted from within a PDF source. IE, "Page 4 of 200", "Page 5 of 200"... etc.
Replies
1
Views
355
smozgur
smozgur
R
  • Question Question
Automating Current Affairs Data Collection into Excel for UPSC Students
Replies
5
Views
234
Fluff
Fluff
W
  • Question Question
How to stop table from loading
Replies
3
Views
2K
johnny51981
J
jimrward
  • Question Question
Static Data in Power Bi Desktop
Replies
5
Views
416
jimrward
jimrward
B
  • Question Question
Macro to refresh PQ
Replies
2
Views
181
RoryA
RoryA

Forum statistics

Threads
1,223,933
Messages
6,175,477
Members
452,646
Latest member
tudou

Share this page

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