Password for connecting to excel spreadsheet?

Posted on 2006-04-16
Last Modified: 2010-04-05
Hi Guyz,

I would like to connect to a excel using the bde.

When I set it up it asks for a username and password. I can set the user name but cannot find where to
set a password.

I'm using delphi 5 enterprise.

Could anyone help please.

Many Thanks
Question by:Asw
    1 Comment
    LVL 26

    Accepted Solution

    create an ODBC DSN to your Excel spreadsheet and drop a TDataBase control on your
    form and set the DatabaseName to your ODBC connection, then setlogin prompt to False
    and Active to True.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
    Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now