I have an excelfile with 2 columns, ordernumber and articlenumber.
I also have a MySQL database containing the same numbers and many more (like deliverydate, price and more).
I established a connection Excel-MySQL using OLEDB and ODBC-DSN, so i can import the entire MySQL table in Excel. This table is 35.000 rows long and takes ages to download in excel
, but i only need the 1 row with the ordernumber and articlenumber to look for the price.
After importing the complete MySQL database in Excel, i am able to look for the desired data (like deliverydate or price) using VLOOKUP.
But i don't want to import the whole sql table.
Is it possible to search (using VBA) for the desired data in the sql table, and only import the data i want?
Many thx!
I also have a MySQL database containing the same numbers and many more (like deliverydate, price and more).
I established a connection Excel-MySQL using OLEDB and ODBC-DSN, so i can import the entire MySQL table in Excel. This table is 35.000 rows long and takes ages to download in excel
, but i only need the 1 row with the ordernumber and articlenumber to look for the price. After importing the complete MySQL database in Excel, i am able to look for the desired data (like deliverydate or price) using VLOOKUP.
But i don't want to import the whole sql table.
Is it possible to search (using VBA) for the desired data in the sql table, and only import the data i want?
Many thx!
