+ Reply to Thread
Results 1 to 3 of 3

excel and data access

  1. #1
    k2sarah
    Guest

    excel and data access

    i have an excel file which i distribute to other people in the organization.
    i will like to also distribute either an access database or sql express
    database, and then have an excel add-in query the database. will this work,
    if my end users do not have either access or sql server?

    thks
    ken

  2. #2
    Tom Ogilvy
    Guest

    RE: excel and data access

    Excel can access an MDB file without having Access installed. I have no
    knowledge of sql express.

    --
    Regards,
    Tom Ogilvy


    "k2sarah" wrote:

    > i have an excel file which i distribute to other people in the organization.
    > i will like to also distribute either an access database or sql express
    > database, and then have an excel add-in query the database. will this work,
    > if my end users do not have either access or sql server?
    >
    > thks
    > ken


  3. #3
    witek
    Guest

    Re: excel and data access

    k2sarah wrote:
    > i have an excel file which i distribute to other people in the organization.
    > i will like to also distribute either an access database or sql express
    > database, and then have an excel add-in query the database. will this work,
    > if my end users do not have either access or sql server?
    >

    Yes. For both
    You can distribute mdb file, and excel can read data using oledb.

    Could you explain whah you mean 'distribute sql express database?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1