Import Excel records to Access using a VB .Net frontend

[Tony A.]

I would like to import records from Excel to an Access DB using a VB .Net
frontend. I thought about creating an Access macro to do the import, and
then run the macro from the VB >Net application, but I'm how to do this or if
it can be done. Any suggestions? Thanks...

 

[Sivakumar O. K.]

One approach is to write a module in MS Access which reads the excel and then
insert the records into the MS Access table. Then the module function can be
invoked from VB.Net application.

The code to invoke Access macro / module is given below.

Dim AccessObject As Object
'Get the MS Access application instance
AccessObject = CreateObject("Access.Application")
'Open the database
AccessObject.OpenCurrentDatabase("C:\db_macro.mdb")
'Hide the application instance
AccessObject.visible = False

'Invoking a module
'AccessObject.Run("module")

'Invoke the access macro
AccessObject.DoCmd.RunMacro("table_save")
'Close the database
AccessObject.CloseCurrentDatabase()
'Quit the instance
AccessObject.Quit()
AccessObject = Nothing