G
Guest
I am interested in importing external data from a MySQL
database into Excel based on the values in an Excel column.
I can import data easily enough, but what I'm looking for
is more of a row-by-row import, with a query like "select *
from table where accountNumber = A1:A10".
For example, a list of 10 account numbers would appear in a
worksheet in column A. I want to populate column B with the
date the account was opened, a value stored in a MySQL
database.
Is something like this possible with Microsoft Query?
Thanks.
database into Excel based on the values in an Excel column.
I can import data easily enough, but what I'm looking for
is more of a row-by-row import, with a query like "select *
from table where accountNumber = A1:A10".
For example, a list of 10 account numbers would appear in a
worksheet in column A. I want to populate column B with the
date the account was opened, a value stored in a MySQL
database.
Is something like this possible with Microsoft Query?
Thanks.