Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Unanswered: database in excel

    Dear Sir

    Will you please let me know is there any database menu in excel
    If it is there please let me know how to handle the database in excel

    I am in this forum to get old version of paradox database which I was using to manage my huge data during 2003-2004. It was a wonderful tool for handling our data and bring multiple reports for our organisation.

    I find it very dificult to get accustamed with Acess database.

    Please help

    thank you

    Bijan Kumar Mitra

  2. #2
    Join Date
    Feb 2009
    Posts
    2
    Dear Sir
    to m
    No sir, I have not received any reply

    I need to know how can i get the old version of paradox database.

    thank you

    Bijan Kumar mitra

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. If it is a large database, then Excel might not be the best for your work. While Excel can do some database things, it is not truly a relational database.

    As for getting an older version of Paradox perhaps you can post in the Paradox portion of this web site.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  4. #4
    Join Date
    Feb 2009
    Posts
    6
    I can not find any database menus in excel sheet,,,though you can link to an access database using following steps
    1.open VBA editor window in excel
    2.from the menu bar select tools>references
    3.from the references dialog box select Microsoft ActiveX data object 2.0 library
    4. use following codes to establish connection
    Code:
        Dim cn As ADODB.Connection
        Dim conStr As String
        conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Visual Studio\VB98\NWIND.MDB;Persist Security Info=False"
        Dim sqlStr As String
        sqlStr = "insert into ......"
        cn.Open
        cn.Execute
        cn.Close

Posting Permissions

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