I want to link data from a database say MS Access to my sheets in excel. What is the best way to do this?
I also want that when data is imported only the data that matches a certain criteria is imported.
I need the data for say sheet 1 to come from two or more access tables or queries. The size of these
tables and queries can vary therefore you cant really know how many rows of data will be
imported. But if possible I want it to be imported as one big list from the database even though
it comes from different tables or queries.
Can I automate the process of checking everytime I open the sheet, that it checks from the
source if there has been any changes to the database. If there are changes then it reloads
the data or if no changes then no action is taken.
How do I go about this? Any ideas? If it involves using VB or VBA please give a few hints
cause I am new to it and learning. Thanks.
I also want that when data is imported only the data that matches a certain criteria is imported.
I need the data for say sheet 1 to come from two or more access tables or queries. The size of these
tables and queries can vary therefore you cant really know how many rows of data will be
imported. But if possible I want it to be imported as one big list from the database even though
it comes from different tables or queries.
Can I automate the process of checking everytime I open the sheet, that it checks from the
source if there has been any changes to the database. If there are changes then it reloads
the data or if no changes then no action is taken.
How do I go about this? Any ideas? If it involves using VB or VBA please give a few hints
cause I am new to it and learning. Thanks.