Connecting VB front end to Excel as a back end

[premMS143]

Hello.,
I want to connect my VB front end application to Excel as a back end,
to save, edit, update, delete etc..
Can anybody help me... Pls...........

Thanking You,
Manju

[QVeen72]

Hi,

Add ADO Reference to your Project,
and use this connection string :

Dim Con as New ADODB.Connection
Dim RST As New ADODB.Recordset
Dim sSQL As String
With Con
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .ConnectionString = "Data Source=C:\MyExcelWB.xls;" & _
        "Extended Properties=Excel 8.0;"
    .Open
End With
sSQL = "SELECT * FROM [Sheet1$]"
RST.Open sSQL,Con,1,3
 
 

Each Worksheet Acts as a Table,
Usually, First Row of the Sheet Is Field Names..
If, not, then Connection string need to be changed to :

"Extended Properties=" " Excel 8.0; HDR=No;" " "
 

REgards
Veena

[premMS143]

Hi,
Thanks a lot.
I get it.
I've created VB application which uses VISDATA as a backend.
Here I used SQL statements for all Queries.
This works well in WIndows XP.
But when I try to install it in UBUNTU.,its showing an error
'Run Time Error 429: ActiveX can't create object.
Would you please help me step by step regarding this.,
Hope I will get solution from you.