Import file from excel (1 Viewer)

[eason]

I have a Access DB and an Excel spread sheet.
What I need to do is have the information, that is enter into the spread sheet, append to my DB. I did not design the spread sheet, and I know there is no table in the spread sheet. This is in a multi-user envoriment. When the user enters info to the spread sheet, some of the info needs to be save into my DB before or when they clear out the info and start a new entry is the spread sheet.

 

[MHM]

You need to write VBA-code für Excel, because excel should provide an event triggering export to access.

Just in case you haven't yet exported from excel to access:

DIM oAcc=Access.Application
set oAcc=getObject("Access.Application")
with oAcc
.hereYouCanPerformAccessCommands
end with
set oAcc=nothing