Access databases other than through ODBC?

[jim.brown1]

I'm looking for a way to access databases (i.e., Oracle or MySQL) from
Excel. The obvious and current solution is to do this through ODBC. I
would prefer a more portable solution as ODBC requires the applicable
driver to be registered. My thought would be point to a file within
VBA that would allow for this. The reason for this, is for portability
- I would like to distribute an Excel file (along with the proper db
file) with connectivity to databases that don't have an ODBC driver
installed by default (i.e, MySQL).

Thank you.

 

[Guest]

Good luck. I'll be watching in hopes you get a good answer. Our MIS folks
won't allow access to any Oracle or SQL Server database except to specific
sign-on's from specific computers......I can't even go to another computer
and use my regular passwords and get in.......I also would like to distribute
Excel files that would allow the user to do queries as I've specifically
outlined by VBA within the file, but no luck yet..........

Vaya con Dios,
Chuck, CABGx3

 

[aaron.kempf]

buddy.. they' cant physcially enforce which computer you sign on FROM
using SQL Server

they can specify what USER is signing on.

but in order to have simple physical security like that; you're going
to need a real database server; like mySql for example

-Aaron