Integrating Excel with Access

[Kenard]

I have been given the task of designing a database that would store customer
information. However, It should be done in a way that when an invioce is
created in excel it will be automatically recorded in the access database.
All help in carrying out this process, is greatly appreciated.

 

[Bre-x]

to a macro on ms access that will get the data from ms excel

DoCmd.TransferSpreadsheet acImport, 8, "MyTable", MyExel, True,
"Print!A4:J18"

On ms excel enter this code

Function SendData()
Dim objAccess As New Access.Application
Dim JCServer
JCServer = ActiveWorkbook.Path & "\New_TC.mdb"
With objAccess
.OpenCurrentDatabase JCServer
.DoCmd.RunMacro "GetData"
.CloseCurrentDatabase
End With
End Function