Insert data from excel to access.

  • Thread starter Thread starter Heera Chavan
  • Start date Start date
H

Heera Chavan

Hi,

I dont know it is posiable or not but I want a macro which can insert data
from excel to access I have the following feilds.

EID, Name, Supervisor Name, Manager Name, Date, Status.

The users of this macro will not have access on there machines.

is it posiable if yes how? Just i need a sample macro.

Regards
Heera
 
I use Docmd.transferspreadsheet acimport, "your table name", "your path like
c: whatever), true
 
Back
Top