K
kuansheng
Each semester a coworker needs to repopulate course data into a
spreadsheet that contains various calculations. I would like to create
a macro/function to pull data from an existing Access database and
populate the spreadsheet with data such as course ID (primary key),
Instructor name, enrollment count etc. The columns needing updating
aren't adjacent to each other.
Doing a query via Excel just puts all the data into the first column
or two. How do I go about mapping the appropriate fields in access to
the corresponding cells in excel? all this without whacking the
underlying formulas.
Anyone can help me out in this? Help is appriciated. Thanks
spreadsheet that contains various calculations. I would like to create
a macro/function to pull data from an existing Access database and
populate the spreadsheet with data such as course ID (primary key),
Instructor name, enrollment count etc. The columns needing updating
aren't adjacent to each other.
Doing a query via Excel just puts all the data into the first column
or two. How do I go about mapping the appropriate fields in access to
the corresponding cells in excel? all this without whacking the
underlying formulas.
Anyone can help me out in this? Help is appriciated. Thanks