Re: ODBC connection to mdb for MacIntosh


"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: New Data Entry Bar Question
    ... I have had my first mac for about a week. ... I saw a feature in excel 2008 that I would like to incorporate into ... Bob Greenblatt, Macintosh ... bobgreenblattATmsnDOTcom ...
    (microsoft.public.mac.office.excel)
  • Re: Userform Image Control and embedded images
    ... > Differences between Excel VBA for Windows and Excel VBA for the Macintosh ... On the Macintosh, ActiveX controls aren't available. ...
    (microsoft.public.excel.programming)
  • Re: ODBC connection to mdb for MacIntosh
    ... 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. ... Fortunately Macintosh Office versions and Microsoft Access both support ODBC, so there is a way to create direct connections to the data tables. ... the Macintosh, they can't find any way to allow you to use an Access DB locally on a Mac. ...
    (microsoft.public.mac.otherproducts)
  • Re: Userform Image Control and embedded images
    ... With the exception of how the images are handled, with Mac XL04, ... Differences between Excel VBA for Windows and Excel VBA for the Macintosh ... On the Macintosh, ActiveX controls aren't available. ...
    (microsoft.public.excel.programming)
  • Re: Missing Features in Excel 2008!?
    ... research program depends very heavily on automated data collection through ... The data collected is sent to Excel where major multi-page macros ... Windows and Macintosh clients in a wide variety of industries, ...
    (microsoft.public.mac.office.excel)