| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting data into Access
I have an existing Access DB that contains a number of
tables. I want to get the data from Excel to specific fields in these existing tables automatically when it is entered in Excel. How do I do this? I have an Excel worksheet with three columns of data. The user enters the data in Excel via a Userform and clicks FINISH when complete and I execute a number of macros to generate some data. I then need this data to go into Access. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting data into Access
Look here Brian
http://www.erlandsendata.no/english/...php?t=envbadac -- Regards Ron de Bruin http://www.rondebruin.nl "BrianC" wrote in message ... I have an existing Access DB that contains a number of tables. I want to get the data from Excel to specific fields in these existing tables automatically when it is entered in Excel. How do I do this? I have an Excel worksheet with three columns of data. The user enters the data in Excel via a Userform and clicks FINISH when complete and I execute a number of macros to generate some data. I then need this data to go into Access. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using Access Data | Charts and Charting in Excel | |||
| Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
| Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
| Access data | Excel Discussion (Misc queries) | |||
| Import data from Access Data Base | Excel Programming | |||
Linear Mode
