How to update ms access tables directly from ms excel?

  • Thread starter Thread starter Guest
  • Start date Start date
Data > GetExternalData > CreateNewQuery > choose MSAccess as the database >
follow the menus.......

hth
Vaya con Dios,
Chuck, CABGx3
 
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.
 
Sorry Nabin, perhaps I misread your post................I thought you were
trying to get data from Access to update your tables in Excel..........sorry,
my bad

Vaya con Dios,
Chuck, CABGx3
 
Back
Top