Re: ODBC connection to mdb for MacIntosh


"Jim Gordon MVP" <goldkey74@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eUzI2JjlFHA.3780@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> Microsoft Query is part of Office 2004 (and previous versions). Excel and
> Word can be used to generate input forms. You can take the data that is
> input and use SQL commands to update Microsoft Access tables.

OK, you're saying that there IS a way to use SQL to update an Access file
that is in fact resident on a Mac and not a PC server? Is this method
available generally through ODBC or something else to all applications, or
do you have to use specifically the Office version of Excel or Word to do
this?

If it's available to other applications, where can I get the drivers to make
it work? If not, can I hook those other applications through one of the
office apps to make the connection in a way that's transparent to the user?

> How much work that involves depends mostly upon your skill set. You will
> need to learn some visual basic and some SQL, neither of which is trivial,
> but both subjects are not too difficult to master for most people.

My experience with the Execute command when called from outside Access is
that it won't execute any VBA functions when called through ODBC from
outside Access, so I think my knowledge of VBA, while pretty good, is
unlikely to be helpful.

> The built-in help system is good. Training materials in the form of books
> and interactive tutorials are available. Have you ever made a visual basic
> macro? Do you know any SQL?

The built-in help does not cover making an access file available cross
platform, that I've been able to tell. If it does, please point me at the
relevant information, and I'll look it up myself.

I know enough SQL to be able to handle the rest, once a connection is made.
All I'm looking to do here is simply make a connection, but since no drivers
come installed on my Mac, that's proving difficult. The only drivers anyone
has pointed me at have been for a mdb that is resident on a PC somewhere,
and that's useless to me.

Thanks;

Amy


.

Relevant Pages

  • SQL in Microsoft Query
    ... I have to do programming because my data is a bit complicated. ... Now I know how to link my Excel file ... Query in order to write SQL. ... Microsoft Query is possible to solve my problem. ...
    (microsoft.public.excel.programming)
  • Re: SQL incorporation with Excel
    ... Excel 2002 VBA by Bullen, Green, Bovey and Rosenberg has a fairly good ... Set a reference to ADO 2.7 in your vb project. ... connection string to find the correct way to connect. ... Our accounting system uses an SQL ...
    (microsoft.public.excel.programming)
  • Re: SQL in Microsoft Query
    ... "SQL in Microsoft Query", please? ... have issuing dates during 1988-2000. ... Now I know how to link my Excel file ... Microsoft Query is possible to solve my problem. ...
    (microsoft.public.excel.programming)
  • RE: SQl Server, Excel 2007 and Refresh All
    ... SQL connection and ditch the fifth datasheet? ... refresh first and then sheet1 refreshes against the database. ... Any Excel experts out there running into this issue? ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: How to import several excel files using one dts package
    ... The article at the link above shows how to import Excel data into SQL ... Server from an indeterminate number of Excel workbooks. ... Designer) between each Excel connection and the SQL Server connection. ...
    (comp.databases.ms-sqlserver)
Loading