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.
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
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 ......"