Re: ADO and Active Server pages on a mac

Mac XL doesn't include ODBC drivers, but you can obtain 3rd party. Have a
look at the two links at the bottom of this page. Perhaps one of them
provides the connectivity:

http://mcgimpsey.com/macoffice/index.html#macxl

I expect you'll get some additional input on the subject, so keep checking
back:)
--
HTH |:>)
Bob Jones
[MVP] Office:Mac

"Janis Rough" <JLRough@xxxxxxxxxxxxx> wrote in message
news:C28C4A44.311E%JLRough@xxxxxxxxxxxxxxxx
Can you use ADO object to connect to an Access database from Excel on a
Mac
on a network? I would like to connect to an Access database using ODBC.
In otherwords does the Excel object model on a Mac have ADO? I know what
the object model is about and an ADO object connection.

Here are the instructions:

Here is how to create a connection to a MS Access Database:

1. Open the ODBC icon in your Control Panel.
2. Choose the System DSN tab.
3. Click on Add in the System DSN tab.
4. Select the Microsoft Access Driver. Click Finish.
5. In the next screen, click Select to locate the database.
6. Give the database a Data Source Name (DSN).
7. Click OK.

So here is the object code:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "northwind"
%>

Does ADO only work on Active Server Pages on a PC? Is Active Server Pages
the middleware to connect to an Access database through a Windows Server
and
IIS? What is the relationship between Active Server Pages and ADO.
I'm confused since I'm on a Mac.
Thanks,
Janis



.

Relevant Pages

  • ADO and Active Server pages on a mac
    ... Can you use ADO object to connect to an Access database from Excel on a Mac ... Does ADO only work on Active Server Pages on a PC? ...
    (microsoft.public.mac.office.excel)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... > Document to connect to a Secured Access Database, ... using the ODBC provider for OLEDB. ... they have a .dsn extension. ... directly (in the Open/Select Data Source dialog box). ...
    (microsoft.public.word.mailmerge.fields)
  • Re: fields queries and utter disaster
    ... I suspect that regrettably, in this case the Excel team got to it, the Word ... Unfortunately the \c ODBC DATABASE field switch is not supported in Word ... Mac Word Test ... suggests that it should be possible to use query files (cf. .qry/.dqy ...
    (microsoft.public.mac.office.word)
  • Re: ODBC connection to mdb for MacIntosh
    ... > Microsoft Access does not exist for the Mac. ... As long as the computer has ODBC drivers for an Access ... You can use the MS Query interface to create any SQL command ...
    (microsoft.public.mac.otherproducts)
  • Re: access Oracle database from Word for Mac
    ... I tried using that ODBC driver before. ... use JAVA applications and JDBC to access the Oracle database and open the ... As far as Word VBA is concerned, ... > Mac VBA documentation discusses calling Mac "Code resources" as the ...
    (microsoft.public.mac.office.word)
Loading