Linking a dynamic database

**mfeng** · 07-11-2013, 10:41 AM

I have a database of data that I want to copy and paste (link) to a new sheet where I can manipulate the data to a more readable form. However, the database does not have a set number of cells and updates regularly (the reason why it needs to be linked). The database changes size on a daily basis either shrinking or expanding. Is there a way to link the database even though it need to be a dynamic range?

**Dave H** · 07-11-2013, 02:56 PM

Use microsoft query. It is the perfect tool for this. On your ribbon on the data tab select get external data from other sources. Then choose microsoft query. You will have to select the driver based on what database you are trying to import from.

**FDibbins** · 07-11-2013, 04:04 PM

It doesnt need tyo be a dynamic range. You can set up the formula on sheet2 to reference the data on sheet1 in such a way that if there is no data in a cell in sheet1, it will show "nothing" in sheet2. something like....

=if(sheet1!A2="","",sheet1!A2)
copied down and across

**mfeng** · 07-12-2013, 08:04 AM

Originally Posted by Dave H

Use microsoft query. It is the perfect tool for this. On your ribbon on the data tab select get external data from other sources. Then choose microsoft query. You will have to select the driver based on what database you are trying to import from.

Will the query table update automatically when the document is opened?