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.

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



"(E-Mail Removed)" wrote:

> 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.
>
>

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


CLR wrote:
> 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
>
>
>
> "(E-Mail Removed)" wrote:
>
> > 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.
> >
> >