Re: [Slightly OT] Smart ODBC bridge needed

If you have SQL Server you can set up a linked server, use the 
"openquery" function to grab the subset of MySQL data you need then do 
the work in a stored procedure and suck it from there, if you have 
Access you can link the tables  or use pass through queries to get the 
data then do the work in VBA in Access, or you could suck the data 
straight into Excel and use VBA behind the scenes to do the work there.

Hope this helps


cheers

mike

Vsevolod (Simon) Ilyushchenko wrote:

> Hi,
>
> This is not exactly in regards to myODBC, but I hope someone can give me
>
> an answer here. I need to import into an Excel spreadsheet some data 
> that live in Mysql on Unix. However, it's not just a select statement 
> from a table - the data are more complex and require processing. Since 
> Mysql has no stored procedures yet, I need to make a call into some 
> programming environment. I am wondering if it's possible to do with 
> ODBC. For example, something like ODBC-to-SOAP translator would be nice 
> - I would write a SOAP module that translates fake SQL statements into 
> procedure calls - something like
>
> "select * from aMethod" -> "&aMethod()"
>
> I have not found anything yet, though. Any non-ODBC suggestions will 
> work too.
>
> Thanks,
> Simon
>  


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx