A
AMK4
Question: Is there a way to have a template in Excel which gets its dat
from an external query?
Explanation: We have an MySQL database of customers that sign-up wit
us. At the moment I have a simply web query in Excel that fetches th
data from the database and drops it into a work book. What we'd lik
to do is create a template with the necessary fields to be filled in
then run the query and have Excel fill in those fields with the data.
Very much like Word does merges I suppose
from an external query?
Explanation: We have an MySQL database of customers that sign-up wit
us. At the moment I have a simply web query in Excel that fetches th
data from the database and drops it into a work book. What we'd lik
to do is create a template with the necessary fields to be filled in
then run the query and have Excel fill in those fields with the data.
Very much like Word does merges I suppose