Running macro in Access from VB Express /Transfer Excel file to Access DB from VB

Hi experts,

I have another problem. I need OR to run a macro in access OR to transfer an excel-file with about 13 colomns into an access database FROM VB.

The code I'm using now is:
        Dim oAccess As Microsoft.Office.Interop.Access.ApplicationClass
        oAccess = CreateObject("Access.Application")
        oAccess.Visible = True
        oAccess.OpenCurrentDatabase(dbpsi_source)
        'Run the macros.
        oAccess.Run("Import_Openfpsi")
        oAccess.DoCmd().Quit(AcQuitOption.acQuitSaveAll)
        System.Runtime.InteropServices.Marshal.ReleaseComObject(oAccess)
        oAccess = Nothing
This "should" work but always returns the error: "can't find the procedure 'Import_Openfpsi.'" (altough the MACRO excists)
The only thing this macro does is transfer an excel file to the access database....(works manually, so macro is ok)
Wouldn't it be better just to code this transfer??? If so, anyone has the code for this?? Or the answer/solution why I get this error?

Thanks for your time.

Regards,
RobStart Free Trial