How to create an ODBC connection with Excel X ?

[Ayato]

Hi I have a huge amount of Excel files developed under Windows, no I am
trying to export them top Mac Os X (panther). Most of them contains VBA code
that will extract/query data from an db (sybase, Oracle, MS-Sql)

The biggest problem I have is to find the correct driver for the Mac.

Any idea what I can do ? Where to find the correct ODBC driver? Any
workaround ?

Please advise,

Ayato

 

[Sean Arney]

Let me know too if you find a driver. The Mactopia info refers to a link to
3rd party ODBC drivers but the page doesn't come up. You will also need
QueryX once you find the driver...


-seanA

 

[Jim Gordon MVP]

Hi,

The Microsoft article should have linked to this URL:
<http://www.openlinksw.com/>

I'll send a note to Microsoft to let them know about the broken link.

-Jim
--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Ayato]

Hi jim,

Thx for the hint but I have already tried that one... you can only dl a demo
version that allows you to extract only 3 rows in your query until you buy
the full version...

Same goes for http://www.actualtechnologies.com/

Any cheap solution for ORACLE db ?

regards,
Ayato

 

[Jim Gordon MVP]

Ah ha! You mean the part about ODBC where you have to pay.

OpenLink announced some time ago that they intend to turn their ODBC drivers
over to Open Source. I would assume at that point they become free (although
not necessarily - many Open Source projects are not free).

But that hasn't happened yet, so for now you have to pay to play.

-Jim

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Sean Arney]

I found this one last night - its golden!

www.actualtechnologies.com

Nice, clean.

-seanA


Jim Gordon MVP

 

[Ted Thibodeau Jr]

[[ This message was both posted and mailed: see
the "To," "Cc," and "Newsgroups" headers for details. ]]

Hi jim,

Thx for the hint but I have already tried that one... you can only dl
a demo version that allows you to extract only 3 rows in your query
until you buy the full version...

This is not accurate.

The downloadable OpenLink driver comes with a 30-day evaluation
license, and is complete unrestricted except for this expiration date
-- you can pull as many records into Excel or other client tools as
will return within 30 days...

Same goes for http://www.actualtechnologies.com/

This is the driver which restrict you to 3 records until you purchase.

Any cheap solution for ORACLE db ?

Do you want cheap, or do you want fully functional, actively supported,
accurate data returns?

OpenLink supplies drivers for Oracle, SQL Server, Sybase, MySQL,
PostgreSQL, Progress, Ingres, Informix, DB2, and many more, in both
Single-Tier (OpenLink components installed only on the Client) and
Multi-Tier (OpenLink components installed on the Client and on the DBMS
host), with the option to install the Multi-Tier in a 3-tier
architecture (OpenLink components installed on the Client and on an
intermediary "gateway" host which also has the DBMS Native Client
components -- Progress Client Networking, Informix-Net, OCI, etc.)....

Best regards,

Ted
OpenLink Support

--
A: Yes. http://learn.to/attribute
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?

Ted Thibodeau, Jr. // voice +1-781-273-0900 x32
Evangelism & Support // mailto:[email protected]
OpenLink Software, Inc. // http://www.openlinksw.com/
http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs http://www.openlinksw.com/weblogs/virtuoso/
http://www.openlinksw.com/blog/~kidehen/
Universal Data Access and Virtual Database Technology Providers

 

[Ted Thibodeau Jr]

[[ This message was both posted and mailed: see
the "To," "Cc," and "Newsgroups" headers for details. ]]

Ah ha! You mean the part about ODBC where you have to pay.

OpenLink announced some time ago that they intend to turn their ODBC
drivers over to Open Source. I would assume at that point they become
free (although not necessarily - many Open Source projects are not
free).

I'm very curious where you heard this announcement.

OpenLink Software maintains and supports a few Open Source projects --
iODBC Driver Manager and associated Driver and Client Application SDK,
OpenLink ODBC Bench, OpenLink JDBC Bench -- but we have never announced
any plans to open-source our Drivers.

Please point me in the direction of this misinformation....

Thanks,

Ted

--
A: Yes. http://learn.to/attribute
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?

Ted Thibodeau, Jr. // voice +1-781-273-0900 x32
Evangelism & Support // mailto:[email protected]
OpenLink Software, Inc. // http://www.openlinksw.com/
http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs http://www.openlinksw.com/weblogs/virtuoso/
http://www.openlinksw.com/blog/~kidehen/
Universal Data Access and Virtual Database Technology Providers