Getting data into Access

B

BrianC

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.
 
Top