importing excel into access through VB

[ashishprem]

Hi,

I am struck up in the end phase of my project development. My requirement is something like this:
I need to import the data from Excel sheet into Access table. The excel file path needs to be selected through Visual Basic GUI. I tried creating a form in MS Access and then import by clicking a button in Access form. The code behind the access button is

Private Sub Command0_Click()
    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "table1", _
            "C:\aa.xls", 1, "Master_sheet!A:H"
End Sub

But I dont know how to implement this import through Visual Basic Window. Any suggestions or other way to implement this.
Thanks guys.

Rgds,
Ash