database in excel

bijanmitra · #1 (**permalink**) 02-15-09, 14:02

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

bijanmitra · #2 (**permalink**) 03-03-09, 12:47

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

shades · #3 (**permalink**) 03-05-09, 20:21

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.

Chris Bode · #4 (**permalink**) 03-12-09, 01:15

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

Internet Services

Web Development

Digital Marketing

Consumer Tech