Re: ODBC connection to mdb for MacIntosh

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.

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.

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?

-Jim

--
Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>


Amy Blankenship wrote:
"Jim Gordon MVP" <goldkey74@xxxxxxxxxxxxxxxxxxxxxx> wrote in message news:u1DAKLSlFHA.3144@xxxxxxxxxxxxxxxxxxxxxxx

Hi Amy,

If you do a Google search in the excel macintosh newsgroup for Access you'll find a lot of information about why there's no Access for Macintosh. The short version is Microsoft does not think they would make a profit on the product, consequently they don't make it.

Fortunately Macintosh Office versions and Microsoft Access both support ODBC, so there is a way to create direct connections to the data tables. Word and Excel are better report generators than the built-in very clumsy report tools in Access. Excel generates better input forms than what can be made in MS Access, so as long as everyone has connectivity to the data tables the database world should go round smoothly.


I understand why they don't make an "authoring" Access for mac. But it seems silly not to make it that an Access DB can live on a Mac and be read and written to through ODBC.

Can Excel emulate a fully normalized database? How much work would that be? Are there any tutorials on how to accomplish this? My purpose is not to open up and run Access anyway, but to do the data entry through a different application that's not in the Office family at all. Would moving to Excel be helpful for that?

Thanks;

Amy 


.

Relevant Pages

  • Re: Benefits of upgrading to Excel2003
    ... You probably don't have access to Excel 2002 and excel 2003 so I've ... Key new features in Microsoft Excel ... Web queries to Extensible Markup Language files. ... If you are not using the specific language version of Microsoft Office ...
    (microsoft.public.excel.misc)
  • Re: Client tools for SQL Server 2005 Analysis Services - Where are they?
    ... "Microsoft also released a Cube add-in for Excel, ... >I have watched webcast after webcast about SQL Server 2005 Business ...
    (microsoft.public.sqlserver.olap)
  • Re: Client tools for SQL Server 2005 Analysis Services - Where are they?
    ... >>I have watched webcast after webcast about SQL Server 2005 Business ... >> touches on their new clients, as well as many other Microsoft Partners ... >> Then there is Excel. ... >> to find that it still costs more to buy the client tools which have ...
    (microsoft.public.sqlserver.olap)
  • Re: Excel 2004 crashes with Right Mouse Button click in OS X 10.4.8
    ... Is your RAM Apple branded, ... Microsoft Office applications? ... I launch Microsoft Excel. ... USB Device: Apple Internal Keyboard / Trackpad, Apple Computer, Up to ...
    (microsoft.public.mac.office.excel)
  • Re: why>?
    ... also; back in the 90s; it might have been a good idea to use Excel. ... Adobe Acrobat and DB2 mainframes-- it is obvious that they need to wake ... Microsoft dug their own hole with regard to antitrust. ...
    (microsoft.public.excel)