|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
December 7th, 2003, 02:16 PM
|
|||
|
|||
|
updating excel from access
I wonder if anyone can throw some light on this.
I have an excel worksheet set up and i have an access database. I was wondering how to update the excel sheet by entering data into the access form. it is office xp i am using. thanks 
|
|
#2
December 8th, 2003, 12:19 PM
|
||||
|
||||
|
Hali,
Create the query/table you wish to be the source for your excel sheet. Open your excel file that you wish to be updated and go to Data -> Import External Data -> New Database Query menu path. Select MS Access Database... ...and the rest is obvious, the wizard will guide you. (Menu items in the English version may be different, I have Hungarian.) Each time a user opens the excel file it will prompt the user if she/he wishes to refresh the spreadsheet with the external data.
__________________
BRegs, TBÁrpi "I can only show you the door. You're the one who has to walk through it." Last edited by TBÁrpi : December 8th, 2003 at 12:21 PM.
|
|
#4
December 9th, 2003, 02:31 PM
|
||||
|
||||
|
I am sure there's a way of doing it, but I'm afraid I can't help as I don't really know the Objects of Ecxel.
Others may help in this forum or if you can try to raise your question on other forums or an Excel forum.
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > updating excel from access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
