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. |
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. |
All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com