| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How 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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to update ms access tables directly from ms excel?
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to update ms access tables directly from ms excel?
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to update ms access tables directly from ms excel?
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 "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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Worksheet Functions | |||
| Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Discussion (Misc queries) | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| Can I directly from Excel publish to Word as in Access | Excel Discussion (Misc queries) | |||
| Import records from Access to Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
