Using the method shown only reads data from excel. You cannot update database
tables using the Ge tExternal Data functionality.

To update tables in Access, you will need to write VBA code to perform this
action. I'm sure someone will have done this, or search the VBA groups on the
net.
--


Alwyas Trying
Eddie


"CLR" wrote:

Data GetExternalData CreateNewQuery choose MSAccess as the database
follow the menus.......

hth
Vaya con Dios,
Chuck, CABGx3



"Nabin" wrote:

I am trying to acquire advance skills in ms-excel that will help me in my
daily job.