 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006How to update ms access tables directly from ms excel?
I am trying to acquire advance skills in ms-excel that will help me in my daily job. Data > GetExternalData > CreateNewQuery > choose MSAccess as the database > follow the menus....... hth Vaya con Dios, Chuck, CABGx3 > I am trying to acquire advance skills in ms-excel that will help me in my > daily job. 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.  SignatureAlwyas Trying Eddie > Data > GetExternalData > CreateNewQuery > choose MSAccess as the database > > follow the menus....... [quoted text clipped - 5 lines] > > I am trying to acquire advance skills in ms-excel that will help me in my > > daily job. 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 > Data > GetExternalData > CreateNewQuery > choose MSAccess as the database > > follow the menus....... [quoted text clipped - 5 lines] > > I am trying to acquire advance skills in ms-excel that will help me in my > > daily job. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.