| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding data from Excel sheet to Access database
Hi
I am a bit of a novice where Access is concerned. Am I able to write some VBA code which will add information entered into an Excel sheet into an Access database? Any examples would be greatly appreciated. Thanks William |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding data from Excel sheet to Access database
Look here William
http://www.erlandsendata.no/english/...php?t=envbadac -- Regards Ron de Bruin http://www.rondebruin.nl "William Francis" <William wrote in message ... Hi I am a bit of a novice where Access is concerned. Am I able to write some VBA code which will add information entered into an Excel sheet into an Access database? Any examples would be greatly appreciated. Thanks William |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding data from Excel sheet to Access database
You can also link or import using wizards. on the access
menu barfile Get external Date Import OR Link. follow the wizard instructions. Linked xl files can be used as tables in access queries. -----Original Message----- Hi I am a bit of a novice where Access is concerned. Am I able to write some VBA code which will add information entered into an Excel sheet into an Access database? Any examples would be greatly appreciated. Thanks William . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to import multiple sheet of excel into Access database to a diffrent tables?? | Excel Discussion (Misc queries) | |||
| Convert MS Excel data to MS Access database | Excel Worksheet Functions | |||
| Excel as Data Entry into Access Database | Excel Discussion (Misc queries) | |||
| excel to get data from an access database | Excel Discussion (Misc queries) | |||
| Exporting data directly from Excel to an un-opened Access database using VBA | Excel Programming | |||
Hybrid Mode
