Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
External data management
Hello,
Is it possible to connect a Microsoft Access table to manage it directly from Excel to get the data synchronized both in Excel and in Access? Thanks, Emiliano |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
External data management
Hi Emiliano:
It is possible to do this. You build your database in access and get it working and then you use querries to look at your data and soem vba to deal with adding and modifying your data. It may be easier just to keep the database in access and build the forms in access. Post a little more information and I will try and give some more advice. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "eggpap" wrote: Hello, Is it possible to connect a Microsoft Access table to manage it directly from Excel to get the data synchronized both in Excel and in Access? Thanks, Emiliano |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
External data management
Hello Martin,
you are very helpfull, but I don't know how to perform this function. May I get a vba sample of management of one Access table by Excel ? Emiliano -- Se hai fretta non hai tempo perché il tempo non ha fretta Emiliano "Martin Fishlock" ha scritto nel messaggio ... Hi Emiliano: It is possible to do this. You build your database in access and get it working and then you use querries to look at your data and soem vba to deal with adding and modifying your data. It may be easier just to keep the database in access and build the forms in access. Post a little more information and I will try and give some more advice. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "eggpap" wrote: Hello, Is it possible to connect a Microsoft Access table to manage it directly from Excel to get the data synchronized both in Excel and in Access? Thanks, Emiliano |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
External data management
Hi:
Have a look here for an example: http://www.paragoncorporation.com/Ar...px?ArticleID=8 It is quite complicated to do and not a trivial matter (done in a controlled and secure way). It depends on your data and how critical it is to the operation of the organization. There are also a number of books for excel database access - have a look in your local library for help or search the web. What are you actually trying to do? -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "eggpap" wrote: Hello Martin, you are very helpfull, but I don't know how to perform this function. May I get a vba sample of management of one Access table by Excel ? Emiliano -- Se hai fretta non hai tempo perché il tempo non ha fretta Emiliano "Martin Fishlock" ha scritto nel messaggio ... Hi Emiliano: It is possible to do this. You build your database in access and get it working and then you use querries to look at your data and soem vba to deal with adding and modifying your data. It may be easier just to keep the database in access and build the forms in access. Post a little more information and I will try and give some more advice. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "eggpap" wrote: Hello, Is it possible to connect a Microsoft Access table to manage it directly from Excel to get the data synchronized both in Excel and in Access? Thanks, Emiliano |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tool bar: Data/Import external data/New database query | Setting up and Configuration of Excel | |||
Tying to extract all data from a pivot pulling from external data | Excel Discussion (Misc queries) | |||
updating external data sheet causes loss of data on linked pages | Excel Worksheet Functions | |||
Data management | Excel Discussion (Misc queries) | |||
External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) |