Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2001
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Get External Data (Mac2001)

    Thought with all the security concerns, that this would be fixed by now. Create a worksheet and populate it with data from an external database, remembering your login so that the data can be refreshed dynamically. Open the worksheet using a text editor, and you will find your login, password, all server and database information (URL, port number, etc) in clear text.

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Excel Get External Data (Mac2001)

    egoldberg

    IMHO if MS fixes these things then people will take Excel seriously and bump Access and SQL and all sorts of other products. This is not good for business.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel Get External Data (Mac2001)

    Wassim,
    I don't think this is part of the MS business plan but rather an oversight on their part! Excel is a lot of things to a lot of people but a viable alternative to a decent database product it is definitely not (for anything but the most simple database). Now, if you claimed it was because they have no real interest in their older products....... <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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