How to import any excel file in datagrid using vb6

[harshala]

I want to open excel file using open dialogue box and display records in datagrid

[sirsnorklingtayo]

I want to open excel file using open dialogue box and display records in datagrid

You can use the ADODB to connect in Excel files just like MS ACCESS
but you need to specify the the filename of the Excel file then try this SQL Statement

SELECT * FROM [Sheet1$]

Sheet1 is the name of the Sheet in Excel file

I hope this one will help you.

'Load the Database Driver for Excel Files
    With mconExcelConnection
           .Provider = "Microsoft.Jet.OLEDB.4.0"
           .ConnectionString = "Data Source= " & gstrExcelPath & ";Extended Properties=Excel 8.0;"
           .CursorLocation = adUseClient
           .Open
    End With
 
mrsetExcelRecordset.Open "SELECT * FROM [TestSheet$]", mconExcelConnection, adOpenKeyset, adLockPessimistic

Norman

[abadillo]

In what part of the code do you make reference to the DataGrid Object?

Thanks!

Abel

[abadillo]

mrsetExcelRecordset.Open "SELECT * FROM " & SelWsheet, mconExcelConnection, adOpenKeyset, adLockPessimistic

What do you see wrong with the piece of code above? It Gives me Run-time error 424 Object Required. "SelWsheet" is a string variable that I get when the user selects from a List Box. It is string and it shows as "InvItem". Does it require an integer? Thanks for your insight!